View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dr. Darrell Dr. Darrell is offline
external usenet poster
 
Posts: 74
Default 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