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
"Peo Sjoblom" wrote:
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
"nastech" wrote in message
...
Looking for a way to exclude Inconsistant Error within a formula, thanks