Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect.ext #value!
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 -- Stuartf ------------------------------------------------------------------------ Stuartf's Profile: http://www.excelforum.com/member.php...o&userid=34535 View this thread: http://www.excelforum.com/showthread...hreadid=545007 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect.ext #value!
Nevermind sumif has sorted it I AM A DOUGHNUT -- Stuartf ------------------------------------------------------------------------ Stuartf's Profile: http://www.excelforum.com/member.php...o&userid=34535 View this thread: http://www.excelforum.com/showthread...hreadid=545007 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect.ext #value!
But it would be nice to display something else instead of #VALUE! Like No Document ??? any suggestions?? -- Stuartf ------------------------------------------------------------------------ Stuartf's Profile: http://www.excelforum.com/member.php...o&userid=34535 View this thread: http://www.excelforum.com/showthread...hreadid=545007 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect.ext #value!
Hi Stuart
You could wrap your formula in an Iserror statement =IF(ISERROR(your_formula),"No Document",your_formula) -- Regards Roger Govier "Stuartf" wrote in message ... But it would be nice to display something else instead of #VALUE! Like No Document ??? any suggestions?? -- Stuartf ------------------------------------------------------------------------ Stuartf's Profile: http://www.excelforum.com/member.php...o&userid=34535 View this thread: http://www.excelforum.com/showthread...hreadid=545007 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDIRECT.EXT Help Required | Excel Worksheet Functions | |||
INDIRECT.EXT | Excel Discussion (Misc queries) | |||
INDIRECT.EXT | Excel Worksheet Functions | |||
Data from closed workbooks (pull func, indirect.ext, etc ....) | Excel Worksheet Functions | |||
Problem with updating values with INDIRECT.EXT | Excel Worksheet Functions |