Having a cell that is dependent on 2 cells returning a certain value
Posted by Chris Jones on June 26, 2001 9:55 AM
I have 2 cells that have a formula in each of them. If another cell meets a certain criteria a value will appear in one or both of these cells. If it doesn't meet the criteria it remains blank.
Now here's my problem. I need a formula to enter in another separate cell, so that this separate cell returns a value of "TRUE", if both the cells mentioned above stay empty. And returns a value of "FALSE", if there is a value in either of the 2 cells, or in both cells.
If you need any additional information or don't know what I'm talking about, just reply with any questions.