IF Issue
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
|