Forum Discussion
Cell not populating correctly based on formula
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
Mickalopagus It sounds like the order should be reversed. Try:
=IF(J16="completed", "Done", IF(I16<>"", "Pending", IF(I15<>"", I15+182, IF(I15="N/A", H$3+60, ""))))
- JMB17, thank you I think this is the correct sequence in the formula! I will begin working with this. I did notice that IF(I15="N/A", H$3+60, "")))) comes back as "#value!"
I am trying to determine what could be causing this as the formula looks correct. Just wondering if you see anything at a glance.
Thank you,
MichaelAn oversight on my part. It also needs to verify I15 is not N/A (the #value is likely because I15 is N/A and it's trying to add 182). Try this:
=IF(J16="completed", "Done", IF(I16<>"", "Pending", IF(AND(I15<>"", ISNUMBER(I15)), I15+182, IF(I15="N/A", H$3+60, ""))))
- Thank you for working through this with me. I have tested it and it is working per the above rules. I appreciate you taking the time!
Michael