Thread: I need to add something onto the formula...Can anyone help?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nicole Nicole is offline
external usenet poster
  
Posts: 53
Default I need to add something onto the formula...Can anyone help?
=SUM(S5:X5)+IF(Q5<R5,R5-Q5,0)+IF(R5<Q5,R5-Q5,0)

I want to add if total is <=0 then =0
Reply With QuoteReply With Quote