var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have two columns that have simple formulas. The data in this worksheet changes once a month.
If one of the fields used in the formula calculations has a 0 (zero) the I receive the terribly despicable #DIV/! error.
I want to replace that with word "Null" without disturbing any formulas.
I've look here but could not find a solution that worked.
Even the built-in search & replace function failed.
All of my data are either numbers, currency, and some percent numbers.
I tried some of the suggestions here and on the Internet but they (or me!) failed in the attempts.
I've also tried the If, Then, Else suggestion without success.
Can't it be something simple?
Thanks . . . Rick
I was able to avoid the #DIV/! error with the following IF statement in cell B1:
with the value in A1 being 0, of course. Is the problem more that you are dealing with formulas that consume other formulas?
have you tried using =IF(ISERROR(YOUR FORMUMA),0,YOUR FORMULA)