0
Why am I getting #NUM error in Excel when trying to input:
=((171757/-201011)^(1/4))-1
It works fine on Wolfram Alpha..
MultiformeIngegno
Posted 2015-07-10T02:02:42.620
Reputation: 305
Excel: Getting #NUM on calc
Answers
1
You need to use imaginary number functions for your equation. Excel expects real numbers for its operations; so it returns #NUM when an imaginary number is created and you didn't specify an imaginary number function.
LDC3
Posted 2015-07-10T02:02:42.620
Reputation: 2 062
1
The fourth root of a negative number will be a complex (real + imaginary) number in the form: a+bi that your Excel formula is unable to manage.
You have to rewrite your formula to:
=IMSUB(IMSQRT(COMPLEX(0,SQRT((171757/201011)))),1)
That will give you the result:
-0,3201569+0,67984i
The same as Wolphram Alpha
jcbermu
Posted 2015-07-10T02:02:42.620
Reputation: 15 868
Run it all the way home. Explain how to accomplish that. – fixer1234 – 2015-07-10T04:02:06.103
@fixer1234 I don't have Excel at home, so I don't know what the functions are. Maybe you could post them and I'll remove my post. – LDC3 – 2015-07-10T04:39:00.357