IF Issue

M

mklapp

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
 
G

Guest

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.
 
R

RagDyeR

Your actual issue here, is that the formula is returning a value that is
*different* from the value contained in the other cell ... BUT ... your
formatting of the formula cell is *only* displaying 7 decimal places.

The proper approach would be to Round() the return of the formula.

i.e.:

Revise
=A1*B1
To
=ROUND(A1*B1,7)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

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
 
R

Ragdyer

Appreciate the feed-back, but ... you've piqued my curiosity now ... what
did you actually *think* the problem was?
 
Top