Your 3 formulas rearranged and made as consistent as possible in terms of FW80 and CH80 comparisons.
=IF(FW80="","Zero Forecast","Okay")
=IF(FW80>CH80,"Stay at Forecast","Adjust to pink")
=IF(AND(FW80>=GD80,GD80>=CH80),"Change to Open","Stay at Forecast")
BE VERY CLEAR that YOUR 1st formula allows FW80 = CH80 AND your 3rd formula allows FW80 = GD80 = CH80, so both formulas allow for equality. My experience leads me to believe that's likely a specification error.
You have these possibilities.
What should the results be for each of these cases? I can guess.
Is that correct? If so, and if NONE of these possibilities should return "Okay", then
=IF(COUNTBLANK(FW80),"Zero Forecast",IF(AND(CH80<=GD80,GD80<=FW80),"Change to Open",IF(FW80<=CH80,"Adjust to pink","Stay at Forecast")))
Bookmarks