2 combined IF formulas

[Tryingtoresolve]

I am trying to get a formula to work I can get each part to work separately but not together plus show NA if no return the formula I am looking at is =IF(E2="HOLD",J2+120)*IF(E2="SALE",J2+30) I can get it to sort of work but J2 is a date and it just returns 00/01/1900 for the formula but works correct if it's just =IF(E2="HOLD",J2+120)

 

[Kerryx]

=IF(E2="HOLD",J2+120,IF(E2="sale",J2+30))

 

[Tryingtoresolve]

Thank you that works great how can I get it to show NA instead of False where the date is not required

 

[Kerryx]

=IF(E2="HOLD",J2+120,IF(E2="sale",J2+30,"NA"))

will show NA if E2 has anything but Sale or Hold

 

[Tryingtoresolve]

Kerryx that's works perfect thank you