Why am I getting #NUM
error in Excel when trying to input:
=((171757/-201011)^(1/4))-1
It works fine on Wolfram Alpha..
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this communityWhy am I getting #NUM
error in Excel when trying to input:
=((171757/-201011)^(1/4))-1
It works fine on Wolfram Alpha..
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.
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