IF problem

users
#1

A            B     C     D    E
3/10/2020    15    KB    0    15

E1 contains this:
=IF(C3="KB",B3/1024,B3)
It displays 15

I tried:
=IF(C3="KB")
It displays TRUE

My formula works elsewhere.
Any ideas?

#2

When I format C as text or all it displays FALSE, not true.

#3

Make sure there is no spaces at all in the C column.
I removed all formatting and your formula result
is .014648438

#4

Very weird, I just closed the file and reoponed it.
Maybe it needed to do a recalculation.

#5

If you make a change to your formula, click in the field
to get it to 'take'.