Formula Help
That's what the first formula of your original message does:
=IF(B26=25,"",IF(G5=G50,"YES",""))
What is your problem?
What are your values in B26, in G5, and in G50? What result does it give,
and what result did you expect?
Note that you haven't specified in your words below what you want if B26<25
and G5<G50, and the formula gives an empty string. If you want something
different, then
=IF(B26=25,"",IF(G5=G50,"YES","whatever alternative result you want"))
--
David Biddulph
"Peter" wrote in message
...
What I want is if B26 is greater than or equal to 25 then nothing
appears in the cell. Then if G5 is greater than or equal to G50, then
I want the word YES to appear in the cell.
....
|