Forum Discussion
simmo81154
Dec 03, 2019Copper Contributor
whats wrong with this formula?
=14.3696*(1-(6.8754*10^5*F39))^5.2559
CA_PUNIT_AGARWAL
Dec 03, 2019Copper Contributor
Please use F9, Evaluate formula.
If you use -1^5.2559 it shows Error in Excel
However if you use Calculator in google, it shows -1
Have to check.
SergeiBaklan
Dec 03, 2019Diamond Contributor
That's since in Excel (and not only) negation has higher priority compare to power. https://support.office.com/en-us/article/calculation-operators-and-precedence-in-excel-48be406d-4975-4d31-b2b8-7af9e0e2878a.
That's a good practice not relay on default behavior but use brackets. If you assume minus for entire result it will be -(1^5.2559), with negation equivalent is (-1)^5.2559