Easy formula question

M

mikeeee

=IF(D4>D5:D6:D7:D8:D9:D10:D11:D12:D13:D14:D15:D16,"Leader","---")
:confused:
I am trying to get a cell to say the word Leader if cell D4 is greate
than the other cells in the list or if D4 is not greater than the cell
in the list to say --- but obviously I have the formula above wron
because it is not working.
Help ASAP please!!!!

Thanks in advance for any help with this,
Mik
 
M

mikeeee

=IF(D4>MAX(D5:D14),"Leader","---")

ok this works but I also need to include cell D3 D2 and D1. In othe
words if cell D4 is greater than all of these it returns the answe
leader or if it is not it returns
 
F

Frank Kabel

Hi
you may try
=IF(D4=MAX(D1:D14),"Leader","")

Note: this may not give you the desired result if you have ties in your
list
 
Top