MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Having a cell that is dependent on 2 cells returning a certain value


Posted by Chris Jones on June 26, 2001 9:55 AM

Hey there

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.

Thank you,

Chris


Posted by IML on June 26, 2001 10:10 AM

If by remain blank, you mean you are populating it with "", then try
=IF(AND(A1="",A2=""),TRUE,FALSE)
where A1 and a2 are your formula cells.

good luck

Posted by Aladin Akyurek on June 26, 2001 10:14 AM

Chris

Lets these 2 cells be A1 and B1.

In C1 enter: ==AND(LEN(A1)=0,LEN(B1)=0)

Aladin

Posted by Chris Jones on June 26, 2001 10:50 AM

The cells will never equal 0 because there is a formula in there. I keep getting true values, even for blank cells.

I tried to do it as =AND(LEN(A!)="",LEN(B1)=""), but that doesn't work either. I'm not sure if I can do this.

Any more help would be great

Chris Chris Lets these 2 cells be A1 and B1. In C1 enter: ==AND(LEN(A1)=0,LEN(B1)=0) Aladin

Posted by Aladin Akyurek on June 26, 2001 11:26 AM

Chris

Try this instead:

=AND(OR(ISBLANK(A1),LEN(A1)=0),OR(ISBLANK(B1),LEN(B1)=0))

Aladin

=========== : Hey Aladin, thanks for the help, but there is a problem with it. The same problem I initially encountered. The cells will never equal 0 because there is a formula in there. I keep getting true values, even for blank cells. I tried to do it as =AND(LEN(A!)="",LEN(B1)=""), but that doesn't work either. I'm not sure if I can do this. Any more help would be great Chris : Chris : Lets these 2 cells be A1 and B1. : In C1 enter: ==AND(LEN(A1)=0,LEN(B1)=0) : Aladin :

Posted by IML on June 26, 2001 11:59 AM

Curious

What is this formula?