Forum Discussion
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...
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,
Michael
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,
Michael
An 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