Excel "IF" Formula for multiple situations

[skeller481]

Will just get right into it:

In column E, I have a received date (for new accounts). In column U, I have expiration dates (for existing accounts). In column J, I have account statutes. I want to put a formula in another column that basically does the following:

If column J says "pending", then add 365 days to the date in column U.
If column J says "received", then add 90 days to the date in column E.
If column J says anything other than "pending" or "received", leave the cell blank.

Obviously have multiple arguments to put into this formula...I know how to speak it but can't get it into a formula to execute.

TIA!

 

[Joe4]

Just use a nested IF statement, like this:

=IF(J2="pending",U2+365,IF(J2="received",E2+90,""))

To learn more, see: Nested If Formula in Excel - EASY Excel Tutorial

 

[skeller481]

Thank you! Worked perfectly - I knew it would be simple. Appreciate your time

 

[Joe4]

You are welcome!