# Check four conditions return TRUE or FALSE

1. ## Check four conditions return TRUE or FALSE

I have several rows with numbers that is either 0, a balance or a text like n/a. I need a formula that return true if all are 0 or contain n/a. If there is one balance shall it be false. Any suggestion? See example: ``Please Login or Register  to view this content.``  Register To Reply

2. ## Re: Check four conditions return TRUE or FALSE

=SUM(A1:D1)=0  Register To Reply

3. ## Re: Check four conditions return TRUE or FALSE

It works, but I can't use it on the example below since it totals to zero. I need a FALSE in the example since there are individual balances.

1000 -1000 0 0 TRUE  Register To Reply

4. ## Re: Check four conditions return TRUE or FALSE

Numerous ways really... another then might be

=MAX(ABS(MIN(A1:D1));MAX(A1:D1))=0

another

=SUM(COUNTIF(A6:D6;{">0"\"<0"})*{1,1})=0  Register To Reply

5. ## Re: Check four conditions return TRUE or FALSE

It works but why do you use ABS on the MIN value. It will work without ABS?  Register To Reply

6. ## Re: Check four conditions return TRUE or FALSE

It will work without ABS?
Not necessarily, no. Consider

A1:D1
-1000 0 n/a 0
E1: =MAX(MIN(A1:D1);MAX(A1:D1))=0 --> returns TRUE as MAX is 0

whereas

E1: =MAX(ABS(MIN(A1:D1);MAX(A1:D1))=0 --> returns FALSE as MAX becomes 1000

If you wish to avoid ABS you could switch to an AND based test, ie:

E1: =AND(MIN(A1:D1)=0;MAX(A1:D1)=0)  Register To Reply

7. ## Re: Check four conditions return TRUE or FALSE

Thank you :-)  Register To Reply