Excel Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to show a Blank in a cell that returns an error message.
I am want to substract 5 days from a date entered in another cell. The problem is that if no date has been entered in the referance cell then I get #value! displayed in the cell. It looks bad and I would like for the the cell with the formula to just show a blank if there is an error.
 
Rick, assuming the date is to be entered in A1, then =IF(A1<>"",A1-5,"").
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com


Rick said:
I need to show a Blank in a cell that returns an error message.
I am want to substract 5 days from a date entered in another cell. The
Click to expand...
problem is that if no date has been entered in the referance cell then I get
#value! displayed in the cell. It looks bad and I would like for the the
cell with the formula to just show a blank if there is an error.
 
You must log in or register to reply here.

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

Help needed 0
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Formula 2
If formula Date not Blank 2
How To Have A Cell Be Blank If... 2
#VALUE 2
Excel formula, sum the value cell and if empty cell left blank 0
Conditional formatting in Excel 2010 2

Back
Top