Forum Discussion
Solved
Fórmula Excel
I have a formula that is not well programmed and the structure does not support me.
I need excel to add according to a condition
if there is a "slight reason" add 2 years to the cell of a date
if there is a "serious reason" add 3 years to the cell of a date
Could you help me, please ?
Thanks
Perhaps you shall use semicolons instead of commas. Please open the file I attached to previous post, that will be correct formula for your locale, Excel transforms it automatically.
7 Replies
Ricard_1967 Try this: =EDATE(date cell, IF(A1="Slight reason", 24, 36))
