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" wrote in message ... 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 |
All times are GMT +1. The time now is 09:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com