Thread: I want to limit the result of a calculation to a maximum number...
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default I want to limit the result of a calculation to a maximum number...
Hi Darrell,

This should do.
=IF(B4=0,0,IF(B6=0,0,IF(B6/(PI()*(B4/12)600,600,B6/(PI()*(B4/12))))

HTH
Martin


Reply With QuoteReply With Quote