View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default 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