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 = ...
- 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
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
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.