If/Then Formula with Projected Dates

aecross

I am looking to create an if/then formula for the below.

I have 2 columns (projected start and projected complete) and I am trying to calculate the projected complete date for a project, but it is dependent on tier levels. I am not quite sure how to tie in the number of days the project will take into the formula.

For example: if the project is a Tier 1, then it will be projected complete in 6 weeks from the projected start date. If the project is a Tier 2, then it will be complete in 2 weeks.

Any and all help is appreciated!

Paul Newcome

Try a nested IF similar to this:

=[Projected Start Date]@row + IF(Tier@row = 1, 42, IF(Tier@row = 2, 14, .....................)))

aecross

Thank you @Paul Newcome!

Having some trouble still - here is the exact formula I have, but it's still showing as unparseable. I have tried moving parentheses around, but still no luck. Any advice?

=[PROJECTED START]@row + IF([TIER LEVEL]@row = I, 60, IF([TIER LEVEL]@row = II, 25))

Paul Newcome

If you are using roman numerals in the tier level column, those are treated as text values and should be wrapped in quotes.

=[PROJECTED START]@row + IF([TIER LEVEL]@row = "I", 60, IF([TIER LEVEL]@row = "II", 25))