Indirect.ext #value!

  • Thread starter Thread starter Stuartf
  • Start date Start date
S

Stuartf

Hi,

Im using Indirect.ext to pull in info from closed workbooks, The
problem is that if a workbook dont exist it displays #VALUE!, im then
doing sum calculations on this pulled in info but because of the
#Value! the sums wont work. Anyone know a work around??

Cheers
 
But it would be nice to display something else instead of #VALUE! Like
No Document ??? any suggestions??
 
Hi Stuart

You could wrap your formula in an Iserror statement
=IF(ISERROR(your_formula),"No Document",your_formula)
 
Back
Top