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?

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

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?