| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to limit the result of a calculation to a maximum number...
I have a formula in a cell; =IF(B4=0,0,IF(B6=0,0,B6/(PI()*(B4/12))))
I never want to display a result greater than 600 and if the result is greater than 600, I want 600 to be displayed. How do I alter my formula to achieve this? Darrell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding maximum qty of items to reach given limit | Excel Worksheet Functions | |||
| Formula for calculating a running balance up to a maximum limit | Excel Worksheet Functions | |||
| Excel Solver (Maximum Limit of no. of variables & constraints) | Excel Discussion (Misc queries) | |||
| Formula to limit the size of a number result in a cell? | Excel Discussion (Misc queries) | |||
| How do I change - increase maximum limit of the row height (409 p. | Excel Discussion (Misc queries) | |||
Threaded Mode
