Thread: if less then zero put zero if greater then zero state number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default if less then zero put zero if greater then zero state number
=MAX(0,7000-c2-e2-g2)

"Pamela Jean" wrote:

I need a formula that goes like this

if 7000-c2-e2-g2 less then zero put zero in column & if 7000-c2-e2-g2 is
greater then zero put the actual sum in column

I need to have both in one column
Reply With QuoteReply With Quote