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