Thread: I need to do a arithmetic if than formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default I need to do a arithmetic if than formula
=max(50,yourcalculation)

may work ok.

Tony wrote:

All excell with give me true and false.

I need to calculate a value vased on two cells. If the end value is 49 or
less I need to have default to 50.

--

Dave Peterson
Reply With QuoteReply With Quote