if function

J

jason2444

in cell A1 i have $30.83 in cell B1 i have $30.83 in cell C1 i have
=IF(A1<=K1,"Correct","Overcharged") cell c1 is returning Overcharged but the
numbers are = anyone know what is going on here?
 
N

Niek Otten

Probably they aren't equal, although they display as equal. Format both as General, widen the columns and you'll probably see
digits differing.
Use the ROUND() function to get around this.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| in cell A1 i have $30.83 in cell B1 i have $30.83 in cell C1 i have
| =IF(A1<=K1,"Correct","Overcharged") cell c1 is returning Overcharged but the
| numbers are = anyone know what is going on here?
 
J

jason2444

jason2444 said:
in cell A1 i have $30.83 in cell B1 i have $30.83 in cell C1 i have
=IF(A1<=K1,"Correct","Overcharged") cell c1 is returning Overcharged but the
numbers are = anyone know what is going on here?
Click to expand...

I ment to type in =IF(A1<=B1
 
P

PCLIVE

Because your formula says "K1" and you said the cell is "B1".
Try this:

=IF(A1<=B1,"Correct","Overcharged")

HTH,
Paul
 
M

Mike H

Jason,

Sounds like it could be a rounding error.
Try this formula
=A1=K1
If it returns false then the numbers aren't equal, increase the decimal
places to see the difference

Mike
 
F

FSt1

hi,
i would check to see how many decimal places the two number extend. you may
have them formated show 2 but the number themselves may have more.
$30.831 would be greater than $30.830
by the way...what's in K1???

regards
FSt1
 
T

Tyro

When you run into things like this it's helpful to put this in a spare cell
=A1=K1 If that returns TRUE, the cells are equal. It's likely the formatted
display makes them look equal when they're really not equal. In that case,
look at the cell contents not the formatted display.

Tyro
 
Top