calculate escalation if dates and values in other columns are met

C2<=(EDATE(C2,60)
sale date is column D not C
((A2+E2)*1.1),(A2+D2)

column A is a dollar value, column D is a date

Thank you, I have tweaked the sample spread sheet but I still cannot get it to work quite the way I would like. Basically what I am trying to calculate is anything orange 5 years old or less attracts an escalation of 10%. That could be 5 years from today or 5 years from a nominated date. Any other colour does not attract the escalation regardless of when it was created However I only want the calculation to be done when there is data in both the Value_A and Value_B fields. I would like it to return the message "Yet to be calculated" when either or both Value_A and Value_B are empty, but when I include this in the formula I get an error message there are too many arguments. I am open to suggestions to make the formula as simple as possible. If there is something other than EDATE that is a better option I am happy to learn it.

Cheers

In F2, copied down:

=IF(B2="","",IF(OR(A2="",E2=""),"TBC",IF(AND(D2<=EDATE(C2,60)),(A2+E2)*1.1,A2+E2)))

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.