none
Chand or overide a formula if a cell reads a certain value RRS feed

  • Question

  • 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

    Saturday, September 10, 2016 6:34 AM

All replies

  • =IF(B1="MS",A2+1908,IF(A1="FF",A2-100,IF(A1="SD",A2+50,IF(A1="REV",A2,""))))

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Saturday, September 10, 2016 9:57 AM