Thread: IF Issue
View Single Post
  #1   Report Post  
mklapp
 
Posts: n/a
Default 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