IF formula needs to read only values, not formulas

E

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
 
N

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
|
|
 
D

dolivastro

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

Dom
 
E

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
 
Top