How do i write this formula in Excel?

[aejaz]

Hello Group

I am resending this..i dont know why this post did not show up.

Anyways,i have this rather simple equation , but cant seem to figure
out how
to write it in excel

x1=x2=x3=x4=x5=x6=x7=x8=x9=x10=x11....upto x32

Initially ,all values are 0. The formula is a part of a linear
program. so when i solve it using solver , the values can change to
satisfy whatever constraints.

But when the values change, i have to make sure ,for example , that
if x1 = 10 , all the other variables are 10.

I could do this manually, but my problem has more than 15 such
equations.

Could you suggest any ideas please?

thanks
aejaz

 

[Tom Ogilvy]

=And(X1=X2,X1=X3,X1=X4,X1=X5,X1=X6,X1=X7,X1=X8,X1=X9,X1=X10)

will test if all the cells are equal.

In your formula (that you showed)

assume X9 does equzal x10, then that evaluates to True. Next you formula
would test is X8=True

which would probably be false and the end result would be false.

 

[Daniel.M]

For aejaz,

=And(X1=X2,X1=X3,X1=X4,X1=X5,X1=X6,X1=X7,X1=X8,X1=X9,X1=X10)

If you're familiar with array formula (Ctrl-Shift-Enter):

=AND(X1=X2:X10)

Regards,

Daniel M.

 

[Tom Ogilvy]

or for a non array solution

=Max(X1:X10)=Min(X1:X10)

or for possible floating point considerations:

=Max(X1:X10)-Min(X1:X10)<0.00001