Forum Discussion

sgtbrowne's avatar
sgtbrowne
Copper Contributor
Mar 08, 2020
Solved

A complicated IF

I have three columns Confidence levels (High, Medium, Low) Training Date Reassessment Date I would like this column to automatically show the date for the following High: add 90 days to trainin...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 08, 2020

    sgtbrowne 

    As variant

    =B1+IFNA(INDEX({30,60,90},MATCH(A1,{"Low","Medium","High"},0)),0)
sgtbrowne's avatar
sgtbrowne
Copper Contributor
Mar 10, 2020

SergeiBaklan I have attached my attempt at this thing along with the error message I am getting

Resources