If Blank

[Ghornet54]

I have the following formula and it works great, however, I need if nothing is in the cell, it to be blank. I don't want the "O" or "X" showing. How do I change my formula?

=IF(AND(AY111>=3.5,AY111<=5.5),"O","X")

Thanks for any help given.

Charles

 

[GTO]

Delete the X but leave the empty quotes?

 

[Bill C]

If you remove the characters x and o from the ending code you will have "" and "" respectively. Is that what you want?

 

[Ghornet54]

If the cell is blank, I want the cell to show blank. If the range is within 3.5 to 5.5, I want an "O", if the range is out of the 3.5 to 5.5, I want an "X".

Hope this makes sense!

Charles

 

[fromspenny]

=if(ay111="","",if(and(ay111>=3.5,ay111<=5.5),"o","x"))

 

[Bill C]

It took me a while but I think this is what you need.

<table border="0" cellpadding="0" cellspacing="0" width="64"><colgroup><col width="64"></colgroup><tbody><tr height="17"> <td style="height:12.75pt;width:48pt" height="17" width="64">'=IF(ISBLANK(E14),"Cell BLANK",IF(AND(E14>=3.5,E14<=5.5),"OK","Failed test"))</td> </tr></tbody></table>
Change what you want in the "text" to say if you need. Use "" to display a blank cell. You can make E14 to AY111 or whatever the target cell is.

Bill C

 

[Ghornet54]

Thanks fromspenny! Works like a charm!

Charles

 

[Bill C]

I'm happy if you are. I sometimes have trouble with syntax when using double If statements and nesting "AND" so I place all the text answers in the outputs and that clears up the smoke. It's easy to get confused.

Bill C

 

[fromspenny]

Happy to help. Thanks for the feedback.

 

[Ghornet54]

I again want to say THANK YOU to both fromspenny and Bill C. This a great forum for novices like me!

Charles