Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help displaying "Maximum" or "Minimum" if cell is max or min in a group?
Hi,
i am creating an excel spreadsheet for a class I am taking. I have a set of numbers (c2:c6), and my prof wants to have "Most Sales in Quarter" or "Fewest Sales in Quarter" displayed in the F column beside the number if it is either the maximum or minimum of the set. I've been at this for a while, and can't figure it out. Anyone help me out? EDIT: The Question is Display the words “Fewest Sales in Quarter” or “Most Sales in Quarter” next to the stores that have the fewest and most sales for that quarter, respectively. Be careful when to use absolute and when to use relative addressing in the formula! Last edited by RussAllison : February 23rd 11 at 09:34 PM |
#2
|
|||
|
|||
Quote:
Dear RussAllison, Good Evening. You can use the MAX and MIN FUNCTIONS to determine the “Fewest Sales in Quarter” or “Most Sales in Quarter”. You can use the IF FUNCTION to ask individually each cell of the C2 : C9 interval to determine if this cell is a MIN or a MAX of the interval. Do this: F2 -- =IF(C2=MIN($C$2:$C$6),"Fewest Sales in Quarter",IF(C2=MAX($C$2:$C$6),"Most Sales in Quarter","")) Copy it down untill F9. Try this one and tell me if it worked for you. Fell free to ask anything about it.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |