How do I calculate a formula with a not-to-exceed answer?

I would like to create a formula that has a not-to-exceed answer.

Example: I want the answer not-to-exceed $10.00

$6.00 + $3.00 = $9.00
$6.00 + $7.00 = $10.00

Put 10 in A3 and your other two numbers in A1 and A2 and use this formula
where you want the answer..........

=MIN(A1+A2,A3)

Vaya con Dios,
Chuck, CABGx3


"danfromthelake" <[email protected]> wrote in message
news:[email protected]...
> I would like to create a formula that has a not-to-exceed answer.
>
> Example: I want the answer not-to-exceed $10.00
>
> $6.00 + $3.00 = $9.00
> $6.00 + $7.00 = $10.00