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