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
Bottom of spreadsheet
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
Bookmarks