Formula to return text if the cell next cell contains maximum or minimum number in a range

**Chypp** · 10-03-2014, 03:23 AM

Hi.
I have a column A1 to A20 containing sums of numbers from other sheets which keep changing. How can I get Excel to put "BEST" in cell B1 if A1 contains the biggest number, and maybe "Worst" in B14 if A14 contains the smallest number. There must be a formula to do this but I just can't get it.

Thanks.

**Pepe Le Mokko** · 10-03-2014, 03:38 AM

Enter the following in B1 and pull down as needed =If(A1=min($a$1:$a$20),"worse",if(a1=max($a$1:$a$20),"best",""))

**Chypp** · 10-03-2014, 03:46 AM

It worked perfectly, thanks a lot!

Formula to return text if the cell next cell contains maximum or minimum number in a range

LinkBack

Thread Tools

Rate This Thread

Display

Formula to return text if the cell next cell contains maximum or minimum number in a range

Re: Formula to return text if the cell next cell contains maximum or minimum number in a r

Re: Formula to return text if the cell next cell contains maximum or minimum number in a r

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] If cell contains text contained in a named range return the row number

[SOLVED] Return Cell Address of Number used in Minimum Function

Looking to return text from a cell based on a minimum value in a range...

[SOLVED] Location of the cells with maximum and minimum values and the text in the cell next to it

Return only unique text from another sheet along with correlating minimum and maximum

Bookmarks

Bookmarks

Posting Permissions