N
nastech
Looking for a way to exclude Inconsistant Error within a formula, thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
exceluserforeman
I suppose you could include the IsError function in the formula
P
Peo Sjoblom
It's always best to find the cause of the error, otherwise you can use
=IF(ISERROR(Formula),"",Formula)
will return blank cell or the non error result of the formula
maybe you could post the offending formula
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
=IF(ISERROR(Formula),"",Formula)
will return blank cell or the non error result of the formula
maybe you could post the offending formula
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
N
nastech
hi, thanks for the answers, reason may seem small after look at different
solution, other than using iserror.
easier to say had multiple equations in a cell, repeated in 4 columns that
referred to repetitive items, anyways out put for all items was stuck with
one result, say "B" for all answers where input over-rides at top of sheet
were for: D M Y (daily monthly, yearly). Was not easy to see difference in
all columns below, so in section header lines merely put: =$A$3 =$B$3
=$C$3 to repeat D M Y that came up with those errors. not that important
now... sorry just deleted repetive equations & changed results to the DMY
.... problems solved, thanks anyways
solution, other than using iserror.
easier to say had multiple equations in a cell, repeated in 4 columns that
referred to repetitive items, anyways out put for all items was stuck with
one result, say "B" for all answers where input over-rides at top of sheet
were for: D M Y (daily monthly, yearly). Was not easy to see difference in
all columns below, so in section header lines merely put: =$A$3 =$B$3
=$C$3 to repeat D M Y that came up with those errors. not that important
now... sorry just deleted repetive equations & changed results to the DMY
.... problems solved, thanks anyways