Only do a formula if cell is occupied

  • Thread starter Thread starter robert_woodie
  • Start date Start date
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
 
Robert

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

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

Andy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the rightmost occupied cell 7
Setting range to last occupied cell 3
How do I insert a watermark over many already occupied cells? 1
IF Formula referring to 2 cells 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Count within a Range Q 10
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
If formula Date not Blank 2

Back
Top