Excel Formulas

R

Rick

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.
 
D

DDM

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.
 
Top