# Remove error message, leave formulas in place

1. ## 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. ``Please Login or Register  to view this content.`` ``Please Login or Register  to view this content.``
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.

S  Register To Reply

2. ## Re: Remove error message, leave formulas in place

Intercept the errors before they occur by checking the divisor cell:

=IF(A81=0, "", SUM((A82-A81)/ABS(A81)))

Another less specific method is to detect all errors after the fact and suppress them:

=IFERROR(SUM((A82-A81)/ABS(A81)), "")  Register To Reply

3. ## Re: Remove error message, leave formulas in place

That actually works great. I was trying to put my IF statement at the end so no wonder i couldnt figure it out.

The very last calculation is always -100% so can i add another part to the IF statement to make it print nothing there as well? Tried this, but im terrible at this stuff.

IF((A4=0, "",A5=0, "") SUM((A5-A4)/ABS(A4)))

Thanks again!!  Register To Reply

4. ## Re: Remove error message, leave formulas in place

Maybe:

=IF(OR(A4=0, A5=0), "", (A5-A4)/ABS(A4))

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.  Register To Reply

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Tags for this Thread #### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1