Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell returns blank result...
I have a formula that I used on a previous spreadsheet. I have changed it to
reflect the current year. The formula yields a result when I click on the formula palette, however the cell display is blank. Any help would be greatly appreciated. I have checked all formatting, conditional formatting, etc. All the other cells that were updated display the results, except for the following. It appears that the formula interprets the iserror as true when it is false... Below is an example of the formula: =IF(ISERROR(SUM(IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$E$2:$E$65000=$A$22,IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$F$2:$F$65000="Total",'http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$I$2:$I$65000,"--"),"-"))),"",SUM(IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$E$2:$E$65000=$A$22,IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$F$2:$F$65000="Total",'http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$I$2:$I$65000,"--"),"-"))) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell returns blank result...
Are you entering the formula as an array?
Try removing the error trap and see what error is being generated. I can't test it with that path! Biff "Leonard" wrote in message ... I have a formula that I used on a previous spreadsheet. I have changed it to reflect the current year. The formula yields a result when I click on the formula palette, however the cell display is blank. Any help would be greatly appreciated. I have checked all formatting, conditional formatting, etc. All the other cells that were updated display the results, except for the following. It appears that the formula interprets the iserror as true when it is false... Below is an example of the formula: =IF(ISERROR(SUM(IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$E$2:$E$65000=$A$22,IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$F$2:$F$65000="Total",'http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$I$2:$I$65000,"--"),"-"))),"",SUM(IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$E$2:$E$65000=$A$22,IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$F$2:$F$65000="Total",'http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$I$2:$I$65000,"--"),"-"))) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell returns blank result...
Thanks for replying... I finally found out... All I needed was to commit the
formula with CTRL shift enter... "T. Valko" wrote: Are you entering the formula as an array? Try removing the error trap and see what error is being generated. I can't test it with that path! Biff "Leonard" wrote in message ... I have a formula that I used on a previous spreadsheet. I have changed it to reflect the current year. The formula yields a result when I click on the formula palette, however the cell display is blank. Any help would be greatly appreciated. I have checked all formatting, conditional formatting, etc. All the other cells that were updated display the results, except for the following. It appears that the formula interprets the iserror as true when it is false... Below is an example of the formula: =IF(ISERROR(SUM(IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$E$2:$E$65000=$A$22,IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$F$2:$F$65000="Total",'http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$I$2:$I$65000,"--"),"-"))),"",SUM(IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$E$2:$E$65000=$A$22,IF('http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$F$2:$F$65000="Total",'http://**2007-as/01-Jan/[TAS20070109.xls]Agent_Report'!$I$2:$I$65000,"--"),"-"))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |