How to computer 100*0.5*0.5*0.5... in Excel?
- Thread starter propro
- Start date
Can you rephrase what you are asking for? I think this is the answer you want, but I don't know.
To enter a formula, start with =.
=100*0.5*0.5*0.5
To fill down
https://support.office.com/en-us/ar...dd-d993-45da-aa82-35a236c5b5db#__toc304980283
To enter a formula, start with =.
=100*0.5*0.5*0.5
To fill down
https://support.office.com/en-us/ar...dd-d993-45da-aa82-35a236c5b5db#__toc304980283
TrainTrackHack
VIP Member
Exponent?
=100*0.5^X
X can be a number or cell. Make a row/column of numbers you want to use as power, and use those cells in place of X.
=100*0.5^X
X can be a number or cell. Make a row/column of numbers you want to use as power, and use those cells in place of X.
yes, Sir.
Intel_man
VIP Member
The power equation you wrote would equate to (100x0.5)^n which is not the same as 100x0.5^n
He just needs to follow what @TrainTrackHack wrote.
TrainTrackHack
VIP Member
That's just the square root of Euler's number
Intel_man
VIP Member
That function is 100*e^0.5 which is not the same as 100*0.5^n
strollin
Well-Known Member
Oops! You're right. The correct formula would be =100*POWER(0.5,n)