| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel performance calculation
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=PRODUCT(1+A1:An)-1 In article , George wrote: HI, Could you let me know if there is an Excel function that calculates the below formula: List of percentages in column A, with the answer I want at the end of the column is as follows: [ (1+A1) x (1 +A2) x ...(1+An) ] -1 i have tried SumProduct but this does not work. Thanks George |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Complex calculation and manipulation in Excel | New Users to Excel | |||
| Hardware for optimum Excel performance | Excel Discussion (Misc queries) | |||
| import Windows Performance Log to excel | Excel Discussion (Misc queries) | |||
Threaded Mode
