Hi

I think that 'counterintuitive' is a brilliant description!!
Two options spring to mind:
Use the ROUND function to round the figures.
Go to Tools|Options|Calculation and set Precision As Displayed. WARNING -
this will set all figures on the spreadsheet to be exactly as they show -
and hence lose decimal places that are not displayed.

--
Andy.


"mklapp" wrote in message
...
Hello,

I am trying to verify mathematical results. My approach is something
like:

(in a Cell) =IF(V4=K4,"Yes","NO")

The problem seem to be that the IF function sees that a formula yielding :

398.8072513

is not = to a cell containing the value:

398.8072513

This seems counterintuitive.

Is there a way to get IF to evaluate the displayed values of the cells
instead of the
comparing the 'formulae'?

Thanks,

mklapp