Condition Statement

D

Django

Appreciate it if anyone could tell be a way to write a IF statement that
states that if a cell is greater than a number of individual cell
write"WINNER"

Or how does one make Excel select the highest number from a group of Cells.

Appreciate any assistance provided.
 
C

Cutter

Assuming you have values in the range A1:A10

then this formula will tell you what the largest number in that range
is:

=MAX(A1:A10)


If you want an IF() function to compare a value in B1 to that range
then use:

=IF(B1>MAX(A1:A10),"WINNER","")
 
C

cottage6

Django, if you still need "Winner" in the cell with the highest number, you
can enter this formula next to each cell with an amount in it.
=IF(A1=MAX(A1:A10),"Winner","")
 
D

Django

Thank you very much.
--
Django


cottage6 said:
Django, if you still need "Winner" in the cell with the highest number, you
can enter this formula next to each cell with an amount in it.
=IF(A1=MAX(A1:A10),"Winner","")
Click to expand...
 
Top