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