Using IF and MAX functions together
 

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

Using IF and MAX functions together
 

Place in say, C4:
=IF(COUNT(B$4:B$11)=0,"",IF(MAX(B$4:B$11)=B4,"high est value",""))
Copy C4 down to C11
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
---
"Michelle" wrote:
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
--
Michelle

Using IF and MAX functions together
 

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


"Michelle" wrote:

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

Using IF and MAX functions together
 

On Sat, 19 Jul 2008 04:22:02 -0700, Michelle
wrote:

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

Using IF and MAX functions together
 

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
---
"Michelle" wrote in message
...
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"," ")
--
Michelle