Maybe,

=IF(C3MAX(E3,G3,I3,K3,M3),1,2)

Mike

"hal" wrote:

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(C3E3&C3G3&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