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.
--
Django

Hello,
The formula to get the highest number is =MAX(A1:A10).

"Django" wrote:

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.
--
Django

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(B1MAX(A1:A10),"WINNER","")


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=399532

Thanks. Thats half my problem solved.
--
Django


"cottage6" wrote:

Hello,
The formula to get the highest number is =MAX(A1:A10).

"Django" wrote:

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.
--
Django

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","")

"Django" wrote:

Thanks. Thats half my problem solved.
--
Django


"cottage6" wrote:

Hello,
The formula to get the highest number is =MAX(A1:A10).

"Django" wrote:

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.
--
Django

Thank you very much.
--
Django


"cottage6" wrote:

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","")

"Django" wrote:

Thanks. Thats half my problem solved.
--
Django


"cottage6" wrote:

Hello,
The formula to get the highest number is =MAX(A1:A10).

"Django" wrote:

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.
--
Django