I am getting stuck having multiple IF statements work for me. I'm not sure if nesting them or having a Macro would be better.
I would like to have a cell in one column read off another cell in another column, and depending on the criteria in that determining column, provide a date that would be 1, 3, or 5 years added to the date and be placed in another cell.
For example from the attached spreadsheet:
If the impact score (column C) is low, moderate, or high, I would like the next assessment (column B) to have added a yearly date of (1 for high, 3 for moderate, and 5 for low) and placed in the next assessment date(column B). I did this with just a low impact score on row 2, but I would like to have all this performed for the moderate and high impacts as well, and I am getting stuck on nesting the statements.
The statement I have is the following:
=IF(C4="HIGH",DATE(YEAR(A4)+1,MONTH(A4),DAY(A4), IF(C4="MODERATE",DATE(YEAR(A4)+3,MONTH(A4),DAY(A4), IF(C4="LOW",DATE(YEAR(A4)+1,MONTH(A4),DAY(A4)))))))
Bookmarks