Thread: simple sum unless blank
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default simple sum unless blank
Hi,

=if(or(i1="",J1=""),"",J1-I1)



"Cheryl" wrote:

simple formula j1-i1 but when I expand down the column I want it to return 0
or leave empty if a cell is blank. Can you help me?


--
Cheryl
Reply With QuoteReply With Quote