Forum Discussion

simmo81154's avatar
simmo81154
Copper Contributor
Dec 03, 2019

whats wrong with this formula?

=14.3696*(1-(6.8754*10^5*F39))^5.2559
excel
PReagan's avatar
PReagan
Bronze Contributor
Dec 03, 2019

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.

simmo81154's avatar
simmo81154
Copper Contributor
Dec 03, 2019

thanks it works fine nowPReagan 

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Dec 03, 2019

    simmo81154 

     

    My pleasure!

Resources