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
|