Raphael Excel
New Member
- Joined
- Mar 16, 2014
- Messages
- 49
I would like to calculate arithmetic and geometric return without calculating intermediate HPR returns.
ie: data set
200
300
400
500
I cannot compute intermediate HPR values (300/200)-1, (400/300)-1 etc.
I need to calculate geometric mean in only one cell and arithmetic mean in only one cell.
I think there's a way using an array function control-shift enter but not sure how.
ie: data set
200
300
400
500
I cannot compute intermediate HPR values (300/200)-1, (400/300)-1 etc.
I need to calculate geometric mean in only one cell and arithmetic mean in only one cell.
I think there's a way using an array function control-shift enter but not sure how.
Last edited: