min or max results

[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)

[RagDyeR]

Try this:

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

--

HTH,

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

"GoofyinNY" <[email protected]> wrote in message
news:[email protected]...
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)

[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)

"GoofyinNY" <[email protected]> wrote in message
news:[email protected]...
> 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)
>

[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


"GoofyinNY" wrote:

> 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)
>