| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculatin NPV for a range of numbers.
hi everyone! i require some assistance with a model i am trying to build. what i want to do is to calcuate the NPV for a range of numbers. i cant do each individually as there are too many combinations (ie costs running from 1000-10000, benefits between 56250 and 84750 with three interest rates). is there anyway i can calculate these values? perhaps i dont need to as all i want to do with the results is run descriptve statistics on them. can anyone help? thanks very much, any help is massively appreciated. j. -- kjd23 ------------------------------------------------------------------------ kjd23's Profile: http://www.excelforum.com/member.php...o&userid=29346 View this thread: http://www.excelforum.com/showthread...hreadid=490565 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| get a count of numbers whose value falls within a given range | Excel Worksheet Functions | |||
| Find Median of Positive numbers only in Range | Excel Worksheet Functions | |||
| Lookup a range of numbers | Excel Discussion (Misc queries) | |||
| occurance of numbers in cell range | Excel Worksheet Functions | |||
Threaded Mode
