if function

H

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&C3>I3&C3>K3&C3>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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if function 3
Multiple IF conditions 3
Word macro that can call cells out of Excel for a find and replace 0
Transfer data between two tables 3
If function across sheets prints value of cell 4
COUNTIF on NonContiguous Cells? 5
Simplifying multiple IF statements? 1
Excel formula for inventory problem 3

Top