Forum Discussion
Decimal numbers in function not working
Hello all! I need help trying to create a function and solve for it. The function I am trying to create is taking: =((D2/5)^1.534) every time I try to solve for it I keep getting #NUM! error m...
ANanfria
It's not that it is the decimal power that's causing the problem, it's the negative value on the other side of the equation that is causing the error. It can be solved mathematically using imaginary numbers, however, this functionality is not available using Excel.
- If it is actually (-.166667^1.534) that you want to calculate, then you can use =IMPOWER(D2,1.534)
