| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| Formula displays does not calculate | Excel Discussion (Misc queries) | |||
| how can i create a formula or format the cells so the answer is a. | Excel Discussion (Misc queries) | |||
| How to solve a formula so that it returns actual answer if negati. | Excel Discussion (Misc queries) | |||
Linear Mode
