Using IF and MAX (and IF and MIN) together

[Becky]

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?

 

[BenjieLop]

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.

 

[Peo Sjoblom]

Something like

=MAX(IF(Range>10,Range))

array entered

--
Regards,

Peo Sjoblom

(No private emails please)