ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   formula result blank (https://www.excelbanter.com/excel-worksheet-functions/125680-formula-result-blank.html)

Leonard

formula result blank
 
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 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,"--"),"-")))


All times are GMT +1. The time now is 04:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com