Forum Discussion
Re: Cell not populating correctly based on formula
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, ""))))
1 Reply
- 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
