| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the sign of a base number for use in XIRR?
I want to use the XIRR function to calculate compound growth rate. You have
to change the sign of the base year and I don't know how to do it in a formula. Please help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the sign of a base number for use in XIRR?
Since the argument for the XIRR function cashflows is a range, I do not think
you can change the sign on a single value of the range. The easiest way to proceed is to enter a negative number for the first year's cash flow: 1/1/2006 -100 1/1/2007 50 1/1/2008 40 1/1/2009 80 Regards... "Dick Cheatham" wrote: I want to use the XIRR function to calculate compound growth rate. You have to change the sign of the base year and I don't know how to do it in a formula. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing a Number in a Column Using Arrays | Excel Worksheet Functions | |||
| Change cell color if it is the lowest number of a group? | Excel Discussion (Misc queries) | |||
| Change number when you open the excel template | Excel Discussion (Misc queries) | |||
| adding a number to every change in value | Excel Discussion (Misc queries) | |||
| XL2000 - How do i change number base? | Excel Discussion (Misc queries) | |||
Linear Mode
