min or max results

G

GoofyinNY

I am trying to include minimum and maximum totals for a customer billing
spreadsheets, B8 and B13 are numbers and I need a minimum of 10.00 and
maximum of 100.00 to be included in the following formula.

Thanks !!

=PRODUCT(B8, B13/100)
 
R

RagDyeR

Try this:

=MAX(10,MIN(B8*B13/100,100))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I am trying to include minimum and maximum totals for a customer billing
spreadsheets, B8 and B13 are numbers and I need a minimum of 10.00 and
maximum of 100.00 to be included in the following formula.

Thanks !!

=PRODUCT(B8, B13/100)
 
B

Bob Phillips

=MAX(MIN(PRODUCT(B8, B13/100),100),10)

odd as it may seem, the MIN statement ensures the max figure, and vice
versa.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
R

Ron Coderre

Let's see if I understand you correctly....
Try this:
=MIN(MAX((B8*(B13/100)),10),100)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top