=IF(B4=0,0,IF(B6=0,0,MIN(600,B6/(PI()*(B4/12)))))
--
David Biddulph

"Dr. Darrell" wrote in message
...
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