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

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

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!
==============================================

"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

Great, it works. I am so glad It is not what I thought it was. Thanks.



"RagDyeR" wrote:

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!
==============================================

"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

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mklapp" wrote in message
...
Great, it works. I am so glad It is not what I thought it was. Thanks.



"RagDyeR" wrote:

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!
==============================================

"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