Inconsistant Formula
 

Looking for a way to exclude Inconsistant Error within a formula, thanks

Inconsistant Formula
 

I suppose you could include the IsError function in the formula



"nastech" wrote:

Looking for a way to exclude Inconsistant Error within a formula, thanks

Inconsistant Formula
 

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

Inconsistant Formula
 

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