Easy Formula Question2

[mikeeee]

=IF(D4>MAX(D514),"Leader","---")

I need a cell to return the value leader if cell D4 is greater than al
the other cells in the range listed above or to return the value--- i
it is not greater. The formula above is working except I need to als
include cells D1 D2 and D3 but am not quite sure what to do.

Thanks in advance

Mikeee

 

[crispbd]

=IF(D4>MAX(D514),"Leader","---")

I need a cell to return the value leader if cell D4 is greater than al
the other cells in the range listed above or to return the value--- i
it is not greater. The formula above is working except I need to als
include cells D1 D2 and D3 but am not quite sure what to do.

Thanks in advance

Mikeeee

This will check to see if D4 is greater than the values in D1-D3 an
D5-D14. Let me know if this what you're looking for.

*=IF(D4>MAX(D13),IF(D4>MAX(D514),"Leader","---"),"---")

 

[Art]

Depending on whether you want all or any of D14 to be greater you could try:

=IF(Max(D14)>MAX(D514),"Leader","---")
=IF(Min(D14)>MAX(D514),"Leader","---")

Art

 

[tjtjjtjt]

Have you tried:
=IF(D4>MAX(D13,D514),"Leader","---")

tj

 

[LPS]

try this....
=if(d4>max(d1:d3,d5:d14),"Leader","---")

 

[mikeeee]

Thanks!!!!!That worked perfectly!!!!!!!!!!!!!!

 

[Frank Kabel]

Hi
see my other post
P.S.: please don't multipost