I need to perform this operation, I have a cell containing numbers from 1 to 8 and I need to generate a cell value based on that. For example, if the value is 1 it must show 0.5 in the next cell. If 2 it must show 0.75 instead, and so on. In practice I need to divide 0.5 by for that many times exceeding 1 in the first cell. with 3 the value returned should be 0.875 what function I need to use? I cannot use macros for this.
sorry, I am too stupid to understand you! please describe more precisly
Being sum of geometric progression [0.5^n], its sum of first n members (where n is in A1) is
=0,5*(0,5^A1-1)/(0,5-1)
or
=(2^A1-1)/(2^A1)
or
=1-0.5^A1
2 Likes
Base^Exponent
There is also a function POWER()
^ circumflex, mostly “above” tab-key, depentend on your keyboardsettings you may to hit the ^key twice:
1 Like
This gives ^^.
Just once, then Space bar.
EDIT: Both ^^ appear at once. That is on Windows environment. Do not remember on Linux.
That’s with dead keys enabled. Dead key - Wikipedia .
I prefer a Compose Key as it doesn’t get in the way typing any of those otherwise dead key symbols. https://en.wikipedia.org/wiki/Compose_key .
1 Like