Hi,
I know how to "hide" this error, per se, Viz. conditional formatting. But there's still that stupid little red triangle in the upper left corner of the cell -- this is what I need to get rid of! I really don't care if I need to disable this error for the entire sheet. Anyone know how???
Thanx a lot,
Jeff
Last edited by gandolff; 01-15-2009 at 10:05 PM.
Knowing there is an error is actually useful, but if you want to suppress it altogether, you can wrap whatever formula is in there into an IFERROR formula.
Let's say the formula in there now is:
=A1/B1*3
To test that for an error, wrap it like so:
=IF(ISERROR(A1/B1*3),"",A1/B1*3)
The only downside is that formula has to run twice every time it's successful. But it's a small sin.
Another way is to know WHERE the error is coming from, such as no data in B1. In that case just check that cell first:
=IF(B1,A1/B1*3,"")
or
=IF(B1=0,"",A1/B1*3)
You get the idea.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanx, bud. I was using =ISNA() w/CF, but this created adscititious problems, erg!... "All is one, and one is all".
Great!
If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]
What problems were caused by Conditional Formatting?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks