Try this:

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

--

HTH,

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

"GoofyinNY" wrote in message
...
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)