Hi all,
I have run across one of my project and could not figure this out.
This is mathematically correct, totally, but excel could not give me
the desired answer:
(-3)^(-2/3) returns #NUM!, but
((-3)^(-2))^(1/3) is ok.
This leads to other problems also if you have time to change the base
for the power function (negative and possitive)
I am using Microsoft XP Professional.
Thanks,
Lmn.
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
poypoy
Hi Nguyen, your problem is not from excel but in your mathematic... You are asking excel to give you imaginary number... In your exemple, try to do your (result ^(-1/2))^3. (-3^[(-2)*(1/3)*(3)*(-1/2)=1] You will have 3 not -3 because by doing ^-2 first, u take out the -.... In fact, you want a 1/ (-3)^2/3 or you won't have a real number with a fraction on ^ exept if the fraction is 1/ (1 or 3 or 5 or 7....)
I let you search the mathematical poof :-)
Best regards Benjamin
Hi all, I have run across one of my project and could not figure this out. This is mathematically correct, totally, but excel could not give me the desired answer: (-3)^(-2/3) returns #NUM!, but ((-3)^(-2))^(1/3) is ok. This leads to other problems also if you have time to change the base for the power function (negative and possitive)
I am using Microsoft XP Professional. Thanks, Lmn.
Hi Nguyen, your problem is not from excel but in your mathematic...
You are asking excel to give you imaginary number...
In your exemple, try to do your (result ^(-1/2))^3.
(-3^[(-2)*(1/3)*(3)*(-1/2)=1] You will have 3 not -3 because by doing ^-2
first, u take out the -....
In fact, you want a 1/ (-3)^2/3 or you won't have a real number with a
fraction on ^ exept if the fraction is 1/ (1 or 3 or 5 or 7....)
I let you search the mathematical poof :-)
Best regards
Benjamin
Hi all,
I have run across one of my project and could not figure this out.
This is mathematically correct, totally, but excel could not give me
the desired answer:
(-3)^(-2/3) returns #NUM!, but
((-3)^(-2))^(1/3) is ok.
This leads to other problems also if you have time to change the base
for the power function (negative and possitive)
I am using Microsoft XP Professional.
Thanks,
Lmn.
Hi Nguyen, your problem is not from excel but in your mathematic... You are asking excel to give you imaginary number... In your exemple, try to do your (result ^(-1/2))^3. (-3^[(-2)*(1/3)*(3)*(-1/2)=1] You will have 3 not -3 because by doing ^-2 first, u take out the -.... In fact, you want a 1/ (-3)^2/3 or you won't have a real number with a fraction on ^ exept if the fraction is 1/ (1 or 3 or 5 or 7....)
I let you search the mathematical poof :-)
Best regards Benjamin
Hi all, I have run across one of my project and could not figure this out. This is mathematically correct, totally, but excel could not give me the desired answer: (-3)^(-2/3) returns #NUM!, but ((-3)^(-2))^(1/3) is ok. This leads to other problems also if you have time to change the base for the power function (negative and possitive)
I am using Microsoft XP Professional. Thanks, Lmn.
Starwing
HI!
=3^-2= Positif =-3^-2=Positif In your example: (-3)^(-2/3) returns #NUM!, because (-2/3)< that 1 -3^-(number<1) it's impossible. in your other example: ((-3)^(-2))^(1/3) is ok.because ((-3)^(-2))=Positif Try =3^(-2/3)
Starwing
HI!
=3^-2= Positif
=-3^-2=Positif
In your example: (-3)^(-2/3) returns #NUM!, because (-2/3)< that 1
-3^-(number<1) it's impossible.
in your other example: ((-3)^(-2))^(1/3) is ok.because ((-3)^(-2))=Positif
Try
=3^(-2/3)
=3^-2= Positif =-3^-2=Positif In your example: (-3)^(-2/3) returns #NUM!, because (-2/3)< that 1 -3^-(number<1) it's impossible. in your other example: ((-3)^(-2))^(1/3) is ok.because ((-3)^(-2))=Positif Try =3^(-2/3)
Starwing
Hi Nguyen, so that... you may experiment this :
IMPOWER(inumber,number) (If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add- in.) Inumber is a complex number you want to raise to a power. Number is the power to which you want to raise the complex number. Remarks : Use COMPLEX to convert real and imaginary coefficients into a complex number. If inumber is not in the form x + yi or x + yj, IMPOWER returns the #NUM! error value. If number is nonnumeric, IMPOWER returns the #VALUE! error value. Number can be an integer, fractional, or negative.
HTH @+
-----Message d'origine----- Hi Nguyen, your problem is not from excel but in your mathematic...
You are asking excel to give you imaginary number... In your exemple, try to do your (result ^(-1/2))^3. (-3^[(-2)*(1/3)*(3)*(-1/2)=1] You will have 3 not -3 because by doing ^-2
first, u take out the -.... In fact, you want a 1/ (-3)^2/3 or you won't have a real number with a
fraction on ^ exept if the fraction is 1/ (1 or 3 or 5 or 7....)
I let you search the mathematical poof :-)
Best regards Benjamin
Hi all, I have run across one of my project and could not figure this out.
This is mathematically correct, totally, but excel could not give me
the desired answer: (-3)^(-2/3) returns #NUM!, but ((-3)^(-2))^(1/3) is ok. This leads to other problems also if you have time to change the base
for the power function (negative and possitive)
I am using Microsoft XP Professional. Thanks, Lmn.
.
Hi Nguyen,
so that...
you may experiment this :
IMPOWER(inumber,number)
(If this function is not available, and returns the
#NAME? error, install and load the Analysis ToolPak add-
in.)
Inumber is a complex number you want to raise to a
power.
Number is the power to which you want to raise the
complex number.
Remarks :
Use COMPLEX to convert real and imaginary coefficients
into a complex number.
If inumber is not in the form x + yi or x + yj, IMPOWER
returns the #NUM! error value.
If number is nonnumeric, IMPOWER returns the #VALUE!
error value.
Number can be an integer, fractional, or negative.
HTH
@+
-----Message d'origine-----
Hi Nguyen, your problem is not from excel but in your
mathematic...
You are asking excel to give you imaginary number...
In your exemple, try to do your (result ^(-1/2))^3.
(-3^[(-2)*(1/3)*(3)*(-1/2)=1] You will have 3 not -3
because by doing ^-2
first, u take out the -....
In fact, you want a 1/ (-3)^2/3 or you won't have a real
number with a
fraction on ^ exept if the fraction is 1/ (1 or 3 or 5
or 7....)
I let you search the mathematical poof :-)
Best regards
Benjamin
Hi all,
I have run across one of my project and could not
figure this out.
This is mathematically correct, totally, but excel
could not give me
the desired answer:
(-3)^(-2/3) returns #NUM!, but
((-3)^(-2))^(1/3) is ok.
This leads to other problems also if you have time to
change the base
for the power function (negative and possitive)
I am using Microsoft XP Professional.
Thanks,
Lmn.
IMPOWER(inumber,number) (If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add- in.) Inumber is a complex number you want to raise to a power. Number is the power to which you want to raise the complex number. Remarks : Use COMPLEX to convert real and imaginary coefficients into a complex number. If inumber is not in the form x + yi or x + yj, IMPOWER returns the #NUM! error value. If number is nonnumeric, IMPOWER returns the #VALUE! error value. Number can be an integer, fractional, or negative.
HTH @+
-----Message d'origine----- Hi Nguyen, your problem is not from excel but in your mathematic...
You are asking excel to give you imaginary number... In your exemple, try to do your (result ^(-1/2))^3. (-3^[(-2)*(1/3)*(3)*(-1/2)=1] You will have 3 not -3 because by doing ^-2
first, u take out the -.... In fact, you want a 1/ (-3)^2/3 or you won't have a real number with a
fraction on ^ exept if the fraction is 1/ (1 or 3 or 5 or 7....)
I let you search the mathematical poof :-)
Best regards Benjamin
Hi all, I have run across one of my project and could not figure this out.
This is mathematically correct, totally, but excel could not give me
the desired answer: (-3)^(-2/3) returns #NUM!, but ((-3)^(-2))^(1/3) is ok. This leads to other problems also if you have time to change the base
for the power function (negative and possitive)
I am using Microsoft XP Professional. Thanks, Lmn.
.
Clément Marcotte
fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français
"Dailoc Nguyen" a écrit dans le message de news:
Hi all, I have run across one of my project and could not figure this out. This is mathematically correct, totally, but excel could not give me the desired answer: (-3)^(-2/3) returns #NUM!, but ((-3)^(-2))^(1/3) is ok. This leads to other problems also if you have time to change the base
for the power function (negative and possitive)
I am using Microsoft XP Professional. Thanks, Lmn.
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
fr = Français
"Dailoc Nguyen" <lmn55378@aol.com> a écrit dans le message de
news:cd732f18.0410280643.7fe6406@posting.google.com...
Hi all,
I have run across one of my project and could not figure this out.
This is mathematically correct, totally, but excel could not give me
the desired answer:
(-3)^(-2/3) returns #NUM!, but
((-3)^(-2))^(1/3) is ok.
This leads to other problems also if you have time to change the
base
for the power function (negative and possitive)
I am using Microsoft XP Professional.
Thanks,
Lmn.
fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français fr = Français
"Dailoc Nguyen" a écrit dans le message de news:
Hi all, I have run across one of my project and could not figure this out. This is mathematically correct, totally, but excel could not give me the desired answer: (-3)^(-2/3) returns #NUM!, but ((-3)^(-2))^(1/3) is ok. This leads to other problems also if you have time to change the base
for the power function (negative and possitive)
I am using Microsoft XP Professional. Thanks, Lmn.
Clément Marcotte
Vous êtes tous trop bons de répondre à quelqu'un qui est trop paresseux pour faire un message en français et qui se prostitue à écrire en anglais à cause d'in infâme "Crosspost" anglais-français.
"Starwing" a écrit dans le message de news:u%23a%
HI!
=3^-2= Positif =-3^-2=Positif In your example: (-3)^(-2/3) returns #NUM!, because (-2/3)< that 1 -3^-(number<1) it's impossible. in your other example: ((-3)^(-2))^(1/3) is ok.because ((-3)^(-2))=Positif
Try =3^(-2/3)
Starwing
Vous êtes tous trop bons de répondre à quelqu'un qui est trop
paresseux pour faire un message en français et qui se prostitue à
écrire en anglais à cause d'in infâme "Crosspost" anglais-français.
"Starwing" <ubik10@hotmail.com> a écrit dans le message de
news:u%23a%23MRQvEHA.1984@TK2MSFTNGP14.phx.gbl...
HI!
=3^-2= Positif
=-3^-2=Positif
In your example: (-3)^(-2/3) returns #NUM!, because (-2/3)< that 1
-3^-(number<1) it's impossible.
in your other example: ((-3)^(-2))^(1/3) is ok.because
((-3)^(-2))=Positif
Vous êtes tous trop bons de répondre à quelqu'un qui est trop paresseux pour faire un message en français et qui se prostitue à écrire en anglais à cause d'in infâme "Crosspost" anglais-français.
"Starwing" a écrit dans le message de news:u%23a%
HI!
=3^-2= Positif =-3^-2=Positif In your example: (-3)^(-2/3) returns #NUM!, because (-2/3)< that 1 -3^-(number<1) it's impossible. in your other example: ((-3)^(-2))^(1/3) is ok.because ((-3)^(-2))=Positif
Try =3^(-2/3)
Starwing
Starwing
:-)
D'accord Clément, I understand... ;-) j'arrête tout de suite...
Starwing "Clément Marcotte" a écrit dans le message de news:
Vous êtes tous trop bons de répondre à quelqu'un qui est trop paresseux pour faire un message en français et qui se prostitue à écrire en anglais à cause d'in infâme "Crosspost" anglais-français.
"Starwing" a écrit dans le message de news:u%23a%
HI!
=3^-2= Positif =-3^-2=Positif In your example: (-3)^(-2/3) returns #NUM!, because (-2/3)< that 1 -3^-(number<1) it's impossible. in your other example: ((-3)^(-2))^(1/3) is ok.because ((-3)^(-2))=Positif
Try =3^(-2/3)
Starwing
:-)
D'accord Clément, I understand... ;-) j'arrête tout de suite...
Starwing
"Clément Marcotte" <clement.marcotte@sympatico.ca> a écrit dans le message
de news:uUfiGfQvEHA.1296@TK2MSFTNGP10.phx.gbl...
Vous êtes tous trop bons de répondre à quelqu'un qui est trop
paresseux pour faire un message en français et qui se prostitue à
écrire en anglais à cause d'in infâme "Crosspost" anglais-français.
"Starwing" <ubik10@hotmail.com> a écrit dans le message de
news:u%23a%23MRQvEHA.1984@TK2MSFTNGP14.phx.gbl...
HI!
=3^-2= Positif
=-3^-2=Positif
In your example: (-3)^(-2/3) returns #NUM!, because (-2/3)< that 1
-3^-(number<1) it's impossible.
in your other example: ((-3)^(-2))^(1/3) is ok.because
((-3)^(-2))=Positif
D'accord Clément, I understand... ;-) j'arrête tout de suite...
Starwing "Clément Marcotte" a écrit dans le message de news:
Vous êtes tous trop bons de répondre à quelqu'un qui est trop paresseux pour faire un message en français et qui se prostitue à écrire en anglais à cause d'in infâme "Crosspost" anglais-français.
"Starwing" a écrit dans le message de news:u%23a%
HI!
=3^-2= Positif =-3^-2=Positif In your example: (-3)^(-2/3) returns #NUM!, because (-2/3)< that 1 -3^-(number<1) it's impossible. in your other example: ((-3)^(-2))^(1/3) is ok.because ((-3)^(-2))=Positif
Try =3^(-2/3)
Starwing
Frank Kabel
Hi and just for the fun of it the result for your original formula would be -0.240375 - 0.416342i
-- Regards Frank Kabel Frankfurt, Germany
"Dailoc Nguyen" schrieb im Newsbeitrag news:
Hi all, I have run across one of my project and could not figure this out. This is mathematically correct, totally, but excel could not give me the desired answer: (-3)^(-2/3) returns #NUM!, but ((-3)^(-2))^(1/3) is ok. This leads to other problems also if you have time to change the base for the power function (negative and possitive)
I am using Microsoft XP Professional. Thanks, Lmn.
Hi
and just for the fun of it the result for your original formula would
be
-0.240375 - 0.416342i
--
Regards
Frank Kabel
Frankfurt, Germany
"Dailoc Nguyen" <lmn55378@aol.com> schrieb im Newsbeitrag
news:cd732f18.0410280643.7fe6406@posting.google.com...
Hi all,
I have run across one of my project and could not figure this out.
This is mathematically correct, totally, but excel could not give me
the desired answer:
(-3)^(-2/3) returns #NUM!, but
((-3)^(-2))^(1/3) is ok.
This leads to other problems also if you have time to change the base
for the power function (negative and possitive)
I am using Microsoft XP Professional.
Thanks,
Lmn.
Hi and just for the fun of it the result for your original formula would be -0.240375 - 0.416342i
-- Regards Frank Kabel Frankfurt, Germany
"Dailoc Nguyen" schrieb im Newsbeitrag news:
Hi all, I have run across one of my project and could not figure this out. This is mathematically correct, totally, but excel could not give me the desired answer: (-3)^(-2/3) returns #NUM!, but ((-3)^(-2))^(1/3) is ok. This leads to other problems also if you have time to change the base for the power function (negative and possitive)
I am using Microsoft XP Professional. Thanks, Lmn.
