Thread: if function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default if function

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

"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?