Cell not populating correctly based on formula

Hello, I am having an issue with an IF statement that is not working properly. Cell that says done is dependent on the other cell saying complete. But if highlighted (green) cell is changed to N/A, t...

excel

Formulas and Functions

Mickalopagus

Copper Contributor

Sep 29, 2022

JMB17

Thank you for your response. I am using Excel 2016.

I am trying to create this formula for H16:

If I15 has 'N/A', populate H16 with date from H3, and add 60 days

If I15 has a date, populate H16 with that date and add 182 days.

If I16 has a date, H16 to display 'Pending'

If J16 is populated with dropdown of 'completed', H16 to display 'Done'.

Each rule would take priority over the one above it, if that makes sense. Thank you for your help with this. I have also tried working with the formula you had presented. However it is giving me a ?Name error.

Excel page:

https://ibb.co/Ykt5B6r

Michael