The error is being generated in the PRODUCT(A1:A12+1) portion of your
formula. What exactly are you trying to do? are you trying to add 1 to each
of the 12 values and then get their product? Trying to convert negative
result to positive?
Might also provide us with the result that you expect given the values in
your example, that would help us see if our offered solution(s) actually work
properly for you.



"spaceage" wrote:

3.51%
3.45%
6.60%
3.04%
3.88%
-7.79%
6.14%
9.08%
-3.63%
0.58%
-9.72%
3.55%

when i enter the formula =product(A1:A12+1)-1, the cell shows the error
#value.

where am I wrong
--
rgds