if function

[hal]

Not sure if this is the best way to go about this, but a scaled down
approach of what i'm trying to do is see if a value in one cell is
greater than five other sells and display certain things based if
that's true or false. Ultimately what i'm trying to do is rank the
values in 6 cells and put in another cell their rank based on which
cell has the higher number. This is the function i've been messing
with:

=IF(C3>E3&C3>G3&I3&K3&M3,1,2)

Even if the function is false is always displays the true value of 1.
Any advice, sites, or better ways to go about this will be
appreciated.

Thanks

 

[Mike H]

Maybe,

=IF(C3>MAX(E3,G3,I3,K3,M3),1,2)

Mike

 

[hal]

needed something like this:

=IF(AND(C3>E3,C3>G3,C3>I3,C3>K3,C3>M3),1,2)

 

[hal]

crap going about this all wrong. i would need too many nested If And
statements to have one cell check 5 other cells to see where it ranks
in value. to many combinations. gonna have to repost the question.
thanks for the response though.