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)
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
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 08, 2020
Or is there a way to make it so every time I make a new row, the formula is there automatically?
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 08, 2020

    sgtbrowne 

    If use Excel Tables formulas will be repeated automatically for every new row of the table.

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

      Is there a way for me to adjust the if so when the confidence and training date hasn't been inputted, the cell stays blank? Right now, it's putting in 1/0/1900.

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

        Actually, can i adjust the if so when the training date column is blank, the reassessment date column is also blank?

Resources