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

[Guest]

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

 

[CLR]

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