This may seem like a elementary question but I guess I never ran into this issue before.
I have a range of values as follows:
A 0
B .5
C .2
D .9
E .1
I am doing a geomean function and need to do the follow formula:
=geomean(1+B1:B5)-1
However, when I evaluate the formula excel is looking at the formula B1:B5 instead of evaluating 1+B1:B5. I keep getting a #VALUE! error.
Bookmarks