G Guest Apr 27, 2005 #1 The CUMIPMT function returns #NAME, even though the Analysis ToolPak is loaded. I am using Excel 2000, SP3. Any ideas? Thanks ...
The CUMIPMT function returns #NAME, even though the Analysis ToolPak is loaded. I am using Excel 2000, SP3. Any ideas? Thanks ...
G Guest Apr 27, 2005 #2 There are 2 Toolpaks - one for the worksheet functions & one for VBA. Are you sure the correct one is loaded?
There are 2 Toolpaks - one for the worksheet functions & one for VBA. Are you sure the correct one is loaded?
G Guest Apr 27, 2005 #3 I've actually loaded both. Duke Carey said: There are 2 Toolpaks - one for the worksheet functions & one for VBA. Are you sure the correct one is loaded? Click to expand...
I've actually loaded both. Duke Carey said: There are 2 Toolpaks - one for the worksheet functions & one for VBA. Are you sure the correct one is loaded? Click to expand...
N N Harkawat Apr 27, 2005 #4 You could use another formula to achieve the same result =sum(ipmt(5%/12,row(indirect(A1&":"&B1)),360,-100,000)) where A1 is the start period and B1 is the end period Array enter it (ctrl+shift+enter)
You could use another formula to achieve the same result =sum(ipmt(5%/12,row(indirect(A1&":"&B1)),360,-100,000)) where A1 is the start period and B1 is the end period Array enter it (ctrl+shift+enter)
