View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bc292 bc292 is offline
external usenet poster
 
Posts: 2
Default Making a cell show blank until data is entered

I am trying to create a formula: =sum(a5,b5,d4). It is a continual
addition/subraction.
The next formula is =sum(a6,b6,d5) etc.
I am trying to make the cell that contains this formula to be blank when
both cells are blank.
I also use cell a5 or b5 for text and I want to be able to ignore the text
and not give an error. I dont always need to add cells a and b. Sometimes I
would only add A cell, sometimes only b cell and sometimes I would need to
add/subtract both
Any assistance is appreciated