Using IF and MAX (and IF and MIN) together

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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?
Click to expand...

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.
 
Something like

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

array entered

--
Regards,

Peo Sjoblom

(No private emails please)
 
Back
Top