Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Product type function H.e.l.p
Hi,
I would like to know if there is a function or combo of functions that can produce the following long form calculation: =(1+A2)*(1+A3)*(1+A4)-1 Where A2, A3 & A4 are percentages. This needs to be done over a whole range of data so the above long form gets a bit tricky. I have tried the following formula "=PRODUCT(1+A2:A4)-1", but this does not give me the same answer as the correct long form. Thanks George |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Product type function H.e.l.p
Try entering your your PRODUCT formula as an array formula, i.e., committing
it with Ctrl-Shift-Enter "George" wrote: Hi, I would like to know if there is a function or combo of functions that can produce the following long form calculation: =(1+A2)*(1+A3)*(1+A4)-1 Where A2, A3 & A4 are percentages. This needs to be done over a whole range of data so the above long form gets a bit tricky. I have tried the following formula "=PRODUCT(1+A2:A4)-1", but this does not give me the same answer as the correct long form. Thanks George |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Product type function H.e.l.p
Thanks Duke,
this was extremely helpful. Is it possible to do the array over a whole column without having to "F2" each cell and then do the ctrl shift enter? Much appreciated. George "Duke Carey" wrote: Try entering your your PRODUCT formula as an array formula, i.e., committing it with Ctrl-Shift-Enter "George" wrote: Hi, I would like to know if there is a function or combo of functions that can produce the following long form calculation: =(1+A2)*(1+A3)*(1+A4)-1 Where A2, A3 & A4 are percentages. This needs to be done over a whole range of data so the above long form gets a bit tricky. I have tried the following formula "=PRODUCT(1+A2:A4)-1", but this does not give me the same answer as the correct long form. Thanks George |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numerical integration | Excel Discussion (Misc queries) | |||
Is there a "concatenateif" type function? (>30 options) in Excel | Excel Worksheet Functions | |||
help please - trouble with sumproduct function | Excel Worksheet Functions | |||
Which Function(s) do I use? | Excel Worksheet Functions | |||
Which function(s)? | Excel Worksheet Functions |