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.