I am looking for two alternative formulas for a single cell, result dependent whether "forecast" or "actual" is in reference cell. Now both formulas work individually, but when combined deliver FALSE when switched to actuals. I am sure this is in the brackets, but can't figure it out, any idea welcome.
=IF(S18="forecast",SUM(S36*(S37+S28),IF(S18="actual",SUMIF('EPOS data download'!$C:$C,'Commercial Engine'!T33,'EPOS data download'!$K:$K))))
Bookmarks