How to check for inconsistent values in a series of numbers

[agencia1]

Hi everyone,

I am trying to write a formula to check for discrepancies. I want the formula to return 'TRUE' if all the non-zero cells have equal values and 'FALSE' if one of the cells has a value which is zero or a number that is not consistent with the other numbers. I tried doing HLOOKUP and can't quite figure it out. Driving me nuts.

For example, I have a row of outputs from cells A1, B1, C1, D1.

A1= 10
B1= 10
C1 = (no number entered)
D1 = (no number entered)

I would want a 'TRUE' here

or....if I have the following

A1= 10
B1= 11
C1 = 10
D1 = (no number entered)

I would want a 'FALSE' here


or....if I have the following

A1= 10
B1= 0
C1 = 10
D1 = (no number entered)

I would want a 'FALSE' here

Thanks!

 

[Rick Rothstein]

I think this formula should work...

=AVERAGE(A1:D1) =MAX( A1:D1)

 

[Fluff]

How about
=AVERAGE(A1:E1)=A1

 

[brownbread]

I'm trying to find a neater way, but this seems to do what you need:

=IF(IFERROR(MATCH(0,A1:D1,0),"err")="err",IF(AND(OR(A1="",MOD(A1,2)=0),OR(B1="",MOD(B1,2)=0),OR(C1="",MOD(C1,2)=0),OR(D1="",MOD(D1,2)=0)),"TRUE","FALSE"),"FALSE")

It tries to find a zero (=FALSE), if not it checks that each cell is either blank or divisible by 2.

Edit: Oops I initially read the word "equal" as "even", and thought that the number 10 could vary across the rows...sorry. Rick's answer is beautifully elegant!

 

[Fluff]

Ignore the formula in post#3
It doesn't work

 

[agencia1]

I think this formula should work...

=AVERAGE(A1:D1) =MAX( A1:D1)

Thanks Rick you are a poet. I would've never thought of something so simple.