My code is displaying "FALSE" when blank..... 1

[TonyU]

I'm trying to modify this code to display a "Blank" cell not the word "False" how can I do this?

=IF(P40="yes","Grain:",IF(P40="no","Fold:&quot)

Thanks

[tt]"A Successful man is one who can build a firm foundation with the bricks that others throw at him"[/tt]

​

 

[rmikesmith]

TonyU,

Modify your formula, as follows:

=IF(P40="yes","Grain:",IF(P40="no","Fold:",""))


HTH
M. Smith

 

[TonyU]

[tt]DUH

Thanks rmikesmith

[tt]"A Successful man is one who can build a firm foundation with the bricks that others throw at him"[/tt]

​

 

[TonyU]

[tt]

Follow up:

Would you know how to display a drop-down menu if a cell = yes using VBA?? (thinking outloud here on something I'm working on)
I can't find any reference anywhere. Thanks

[tt]"A Successful man is one who can build a firm foundation with the bricks that others throw at him"[/tt]

​