IF formula needs to read only values, not formulas

[Ed]

I have an IF formula down column F, and am trying to read the results with
another IF formula in column G:
=IF(F5 > 1/32, "Yes", "")
But the formula in column G gives "Yes" when the cell in column F is filled
only with the formula, not a result.

How can I make this work?

Ed

 

[Niek Otten]

Hi Ed,

Please tell us what the exact formulas in F and G are; that is not clear from your post.
What are the values involved? Are any of the columns formatted as Text before you entered the formulas?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have an IF formula down column F, and am trying to read the results with
| another IF formula in column G:
| =IF(F5 > 1/32, "Yes", "")
| But the formula in column G gives "Yes" when the cell in column F is filled
| only with the formula, not a result.
|
| How can I make this work?
|
| Ed
|
|

 

[dolivastro]

What you descibe should work fine, at least if column F has a number,
and not text that looks like a number.

Dom

 

[Ed]

Hi, Niek.
In F I have:
=IF(E53<>"",SUM(B53,E53),"")
The cells in F are formatted as Fraction.

The forumla in G is:
=IF(F53>1/32, "Yes","")
Those cells actually have a Custom format of 0.0_)
I have no idea what that means, as I didn't out it there. The only thing
that would go down that column is text.

Ed