Remove error message, leave formulas in place

I would like to be able to add info at a later date and have the formulas there, but i dont want to see an error if there is no information yet. This thread has a way to clear the errors out but clears the entire cell
http://www.excelforum.com/excel-prog...g-formula.html

Below is how mine looks now.

Top of spreadsheet

 
Stand Dev	Stand Dev	Stand Dev	Stand Dev %	Stand Dev %	Stand Dev %
0.608903671	1.03157688	0.722911973	0.856%	0.713%	0.723%
26.94	57.82	38.90	-0.07%	-0.14%	0.05%
26.92	57.74	38.92	-0.52%	-0.28%	-0.31%
26.78	57.58	38.80	0.63%	0.52%	0.54%
26.95	57.88	39.01	0.26%	-0.05%	-0.13%
27.02	57.85	38.96	0.07%	-0.38%	0.00%

Bottom of spreadsheet

 
27.60	58.49	39.84	0.18%	0.29%	0.25%
27.65	58.66	39.94	0.51%	0.22%	0.33%
27.79	58.79	40.07	0.97%	0.56%	0.20%
28.06	59.12	40.15	-0.39%	-0.37%	0.05%
27.95	58.90	40.17	0.14%	-0.15%	0.12%
27.99	58.81	40.22	-1.29%	-0.85%	-0.65%
27.63	58.31	39.96	-100.00%	-100.00%	-100.00%
			#DIV/0!	#DIV/0!	#DIV/0!
			#DIV/0!	#DIV/0!	#DIV/0!
			#DIV/0!	#DIV/0!	#DIV/0!
			#DIV/0!	#DIV/0!	#DIV/0!
			#DIV/0!	#DIV/0!	#DIV/0!
			#DIV/0!	#DIV/0!	#DIV/0!
			#DIV/0!	#DIV/0!	#DIV/0!
			#DIV/0!	#DIV/0!	#DIV/0!

I input data in the first 3 columns. =SUM((A82-A81)/ABS(A81)) is the formula, and then =STDEV.S(D4:D81) looks at the entire row. STDEV ignores blanks and text, but the errors screw it up.

Thanks in advance!

S