Thread: if function
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default if function

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

"jason2444" wrote in message
...
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?