I have setup a IF OR function, but I need to put a third option on there and I am having trouble.
What I have currently. **A**
=IF(OR(D17=AB6,D17=AB7), "Target Change: ", "Current Target: ")
What I want to add (RED UNCERTAINTY) ***B***
=IF(OR(D17=AB6,D17=AB7,D17=AB8,) "Target Change: ", "Current Target: ", Suggested Target: ",)
The function works in **A**, but I am unsure how to get ***B*** to work & demonstrate what I would like to see.
Thanks for your help.
Bookmarks