Using IF and MAX functions together

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

Hi

I have a study question I need to complete, which I'm struggling with. I
have a list of varying $ values and I need to use the IF and MAX functions to

a) determine the highest value in the list; and
b) return the words "highest value" beside the highest number, and leave the
remainder blank.

I have tried using: =IF(MAX(B4:B11),"highest value"," ")

but this returns the words "highest value" beside every value, whether it is
the highest, lowest or in the middle.

Can someone please help?

Thanks
 
I just cracked it myself... very satisfying. I used:

=IF(GETPIVOTDATA("Extended Price",$A$3,"Product Name","Chicken burger low
fat frozen - mega pack")=MAX(B4:B11),"highest value"," ")
 
Hi

I have a study question I need to complete, which I'm struggling with. I
have a list of varying $ values and I need to use the IF and MAX functions to

a) determine the highest value in the list; and
b) return the words "highest value" beside the highest number, and leave the
remainder blank.

I have tried using: =IF(MAX(B4:B11),"highest value"," ")

but this returns the words "highest value" beside every value, whether it is
the highest, lowest or in the middle.

Can someone please help?

Thanks
Click to expand...


I guess your $ data are in column B from row 4 to row 11.
if you enter the following formula in cell C4 and copy it down to C11
you will have the words "highest value" beside the highest number, but
not in the same cell. It will be in the cell to the right of the
highest number, that is in the column C. Is that what you want?

=IF(B4=MAX(B$4:B$11),"highest value","")

Hope this helps / Lars-Åke
 
Back
Top