Only do a formula if cell is occupied

R

robert_woodie

I would only like excel to work out my formula if 2 cells are occupied,
if they are not occupied i wanted the cell to be left blank.
The problem occurs becuase if the cells are empty the formula gives a
negative date answer and displays it as ########.

thanks in advance.
Robert
 
A

Andy B

Robert

You'll have to enclose the formula in an IF statement. Try

=IF(AND(firstcell <>"", secondcell<>""),formula,"")

Andy.
 
Top