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