Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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,"--"),"-"))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rs.10,250.00 formula Rupees ten thousand two hundred fifty only | New Users to Excel | |||
how to use spellnumber formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How to get a formula result zero as blank cell | Excel Discussion (Misc queries) | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions |