Needing Help with Multiple Logical Expressions Formula
I am working on a formula that will look at a few different cells and make a calculation. I need the formula to look at
ETA to Ready = [terminal ETA] + [# of days]
The [# of days] is determined by which [Terminal] So I need the formula to look at the value in the [Terminal] column, then add the associated [# of days] to the [Terminal ETA] date for the actual [ETA to Ready]
For example, if the Terminal ETA date is 4/10/19 and the Terminal is "APM" which is associated with a "3 day" I would want the formula to return a value of 4/13/19. Not sure if I'm making sense with this formula, but would love some assistance.