Using IF and MAX functions together

[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

 

[Max]

Place in say, C4:
=IF(COUNT(B$4:B$11)=0,"",IF(MAX(B$4:B$11)=B4,"highest value",""))
Copy C4 down to C11
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik

 

[Michelle]

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

 

[Lars-Åke Aspelin]

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

 

[Max]

Good to hear that

I'd bet my last 2 cents that no responder could have
come up with the solution that you posted below,
based on your original posting <g>
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 16,200, Files: 354, Subscribers: 53
xdemechanik