Forum Discussion
simmo81154
Dec 03, 2019Copper Contributor
whats wrong with this formula?
=14.3696*(1-(6.8754*10^5*F39))^5.2559
13 Replies
- SergeiBaklanDiamond Contributor
Just in case, that is interesting reading about the issue http://mathforum.org/library/drmath/view/62979.html
- simmo81154Copper Contributorthank you
- PReaganBronze Contributor
Hello simmo81154,
The root of a negative value is imaginary. I assume you are receiving a #NUM! error?
For example if F39=1, then your formula equates to -9879660.4144^5.2559 which is imaginary.
If you can explain your goal with this formula, I may be able to offer a valid suggestion.
P.S. Highlighting part of a formula and pressing F9 shows what that part of the formula equates to. This is perfect for trying to discover where a formula is giving an error.
- simmo81154Copper Contributor
thanks it works fine nowPReagan
- PReaganBronze Contributor
- CA_PUNIT_AGARWALCopper ContributorWhen I copy and paste your formula, I get the result as 14.3696 Please elaborate
- simmo81154Copper Contributorthanks, I have it working now