Using decision symbols to change text
Please can somebody help me, I'm new to formulas!
I'm trying to get text in a cell to change depending on what decision symbol has bee selected (YES, NO, HOLD)
I managed to get it working with just 'YES' as follows:
=IF(Graphic6 = "YES", "Includes GRAPHICS see schedule")
but I also want different text "No GRAPHICS" to appear if the 'NO' is selected. I have a feeling I need an OR statement, but i can't get it to work. Suggestions would be much appreciated.
Thanks.
Comments

Hi Tim,
Try use this formula:
=IF([your column name]1 = "yes"; "yes statement"; IF([your column name]1 = "hold"; "hold statement"; "no")) and please let me know if it works for you.

Thank you Marcin. Unfortunately that comes out as #UNPARSEABLE

Well I got it to work with the formula below, which is essentially your formula, but retyped! Must have been a tiny difference I'm missing, any how it works now:
=IF(Graphic6 = "yes", "yes statement", IF(Graphic6 = "no", "no statement"))
Thanks for your help.

Glad to hear that!
Depend on users location and probably keyboard settings, there is a difference between separation marks in formulas. You use comma in formulas and I ahve to use semicolon. Also I see that your formula has no square brackets, while mine has
Help Article Resources
Categories
Check out the Formula Handbook template!