I have a complex formula within my spreadsheet using the IF function with 3 variables. I now want the option to over ride this whole formula if cell (B1) equals 'MS'.
So, if B1='MS' I want the rule to be ignored and add 1908 to value in (A2) and calculated in cell A3.
The rule I am working with is:
A3 =IF(A1="FF",A2-100,IF(A1="SD",A2+50,IF(A1="REV",A2,"")))
How can I do this? Thanks in advance
Bookmarks