Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default #REF!, TRUE or FALSE


Hi everybody

Im working on a worksheet where i wanna check cells in two other types
of work sheets but but only one of the exists for each number.

Ive made this cell: "=OR(SUM(INDIRECT("'[Kreditor mappe
"&B9&".xls]Løndebitorer'!$L:$L"))+SUM(INDIRECT("'[Kreditor mappe
"&B9&".xls]Ferieval.'!$L$1:$L$40"))0;SUM(INDIRECT("'[Debitor mappe
"&B9&".xls]Løndebitorer'!$L:$L"))+SUM(INDIRECT("'[Debitor mappe
"&B9&".xls]Ferieval.'!$L$1:$L$40"))0)" but of course i get #REF!
because one of the files are missing, i want to know how i can set
#REF!=0 and even if i didnt have that problem i would still only get a
true or false answer. And i want a 1 or 0 answer. I cant figure out how
to get "=if()" to recognize if the "=or()" result is right.

I really hope theres a hardcore excel user out there that can help me


--
Hurtige
------------------------------------------------------------------------
Hurtige's Profile: http://www.excelforum.com/member.php...o&userid=37381
View this thread: http://www.excelforum.com/showthread...hreadid=570694

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,441
Default #REF!, TRUE or FALSE

Hurtige,

Generally, you need to wrap at least one indirect in the iserror function to trap the error..

Perhaps:

=IF(ISERROR(INDIRECT("'[Kreditor mappe
"&B9&".xls]Løndebitorer'!$L:$L")),SUM(INDIRECT("'[Kreditor mappe
"&B9&".xls]Ferieval.'!$L$1:$L$40")),SUM(INDIRECT("'[Kreditor mappe
"&B9&".xls]Løndebitorer'!$L:$L")))


HTH,
Bernie
MS Excel MVP


"Hurtige" wrote in message
...

Hi everybody

Im working on a worksheet where i wanna check cells in two other types
of work sheets but but only one of the exists for each number.

Ive made this cell: "=OR(SUM(INDIRECT("'[Kreditor mappe
"&B9&".xls]Løndebitorer'!$L:$L"))+SUM(INDIRECT("'[Kreditor mappe
"&B9&".xls]Ferieval.'!$L$1:$L$40"))0;SUM(INDIRECT("'[Debitor mappe
"&B9&".xls]Løndebitorer'!$L:$L"))+SUM(INDIRECT("'[Debitor mappe
"&B9&".xls]Ferieval.'!$L$1:$L$40"))0)" but of course i get #REF!
because one of the files are missing, i want to know how i can set
#REF!=0 and even if i didnt have that problem i would still only get a
true or false answer. And i want a 1 or 0 answer. I cant figure out how
to get "=if()" to recognize if the "=or()" result is right.

I really hope theres a hardcore excel user out there that can help me


--
Hurtige
------------------------------------------------------------------------
Hurtige's Profile: http://www.excelforum.com/member.php...o&userid=37381
View this thread: http://www.excelforum.com/showthread...hreadid=570694



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop renaming or moving sheet tabs sparx Excel Discussion (Misc queries) 9 May 16th 06 08:44 PM
Disable CUT via toolbars or shortcut keys sparx Excel Discussion (Misc queries) 0 April 30th 06 08:34 PM
Disable "Cut" only sparx Excel Discussion (Misc queries) 2 April 29th 06 05:08 PM
Help: runtime error - Method seriescollection object_chart failed huangx06 Charts and Charting in Excel 3 July 9th 05 12:27 AM
Grand Totals @ Same Place Amber M Excel Worksheet Functions 2 December 30th 04 08:13 PM


All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"