|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 30th, 2005, 02:01 AM
|
|||
|
|||
Using IF and MAX (and IF and MIN) together
I am a newbie to Excel. I have a spreadsheet for a class in which I am
required to find the most sales by using IF and MAX. Also, I must find the least sales using IF and MIN. Can anyone help me put a formula together? 
|
|
#2
August 30th, 2005, 02:16 AM
|
|||
|
|||
|
Becky Wrote: I am a newbie to Excel. I have a spreadsheet for a class in which I am required to find the most sales by using IF and MAX. Also, I must find the least sales using IF and MIN. Can anyone help me put a formula together? Assuming your sales figures are in A1:A100, use *=max(A1:A100) * to determine the maximum number in the range and *=min(A1:A100) * to determine the minimum number in the range. Based on your post, I do not see why IF is needed. Hope this helps you. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=400315
|
|
#3
August 30th, 2005, 02:20 AM
|
|||
|
|||
|
Something like
=MAX(IF(Range10,Range)) array entered -- Regards, Peo Sjoblom (No private emails please) "Becky" wrote in message ... I am a newbie to Excel. I have a spreadsheet for a class in which I am required to find the most sales by using IF and MAX. Also, I must find the least sales using IF and MIN. Can anyone help me put a formula together?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
