Using decision symbols to change text

tim@gyroscope

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.

Marcin P

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.

 

tim@gyroscope

Thank you Marcin. Unfortunately that comes out as #UNPARSEABLE

tim@gyroscope

Well I got it to work with the formula below, which is essentially your formula, but re-typed! 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.

Marcin P

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