Forum Discussion
Solved
Power Formula
I believe these two formulas should provide the same answer, but they don't. Can someone please explain why or what I have wrong. The power formula works fine with whole numbers.
=0.01*2^30 = 10,737,418 --> This one is the correct answer.
=POWER(0.01*2,30) = 1.07E-51
Thanks, Nick
- I think the order of operations may be the issue.
In the first formula, it's equivalent to 0.01 * (2^30).
In the second formula, the equivalent formula is (0.01 * 2) ^ 30.
The effective parentheses are in different spots. If you want the POWER formula to match the first formula, you can do this: =POWER(2, 30)*0.01
2 Replies
- I think the order of operations may be the issue.
In the first formula, it's equivalent to 0.01 * (2^30).
In the second formula, the equivalent formula is (0.01 * 2) ^ 30.
The effective parentheses are in different spots. If you want the POWER formula to match the first formula, you can do this: =POWER(2, 30)*0.01- Got it. Thanks for the quick reply.
