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...
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
Michael