Forum Discussion
Solved
Ms-Excel has wrong functions in Exponential (I think that's true)
Dear Ms-Excel team, Fist of all I want to say thank MS who created wonderful app (Ms-Excel). However, I believe there are some error in Exponential functions. Ex. Let calculate some functions bell...
Thank Sergei Baklan, I understand your explanation with fully reference from MS-links.
MS-Excel is correct with MS-Excel's order of calculation (from left to right).
But, do you agree with me about the Basic Calculation in Math what we learned at school? About the order of calculation:
1. Exponential
2. Sqrt
3. Bracket
4. */
5. +-
6. Left to Right
And, I wondering How can I type correctly functions in Excel if I Excel calculate S1 to S6 in my example? Results from S1 to S6 will be store in cells from G3 to G8 in my attached picture.
MS-Excel is correct with MS-Excel's order of calculation (from left to right).
But, do you agree with me about the Basic Calculation in Math what we learned at school? About the order of calculation:
1. Exponential
2. Sqrt
3. Bracket
4. */
5. +-
6. Left to Right
And, I wondering How can I type correctly functions in Excel if I Excel calculate S1 to S6 in my example? Results from S1 to S6 will be store in cells from G3 to G8 in my attached picture.
- Yeah, just need some (). Thank Sergei
duypk , you are welcome