Can anyone help with excel for calculating the following? To calculate the expression Ac = Av*exp(j*Phase_v*pi/180) +j*Ah*exp(j*Phase_h*pi/180)?

[aparnaverd]

Can anyone help with excel for calculating the following? To calculate the expression Ac = Av*exp(j*Phase_v*pi/180) +j*Ah*exp(j*Phase_h*pi/180)?

 

[RobP]

Hi, welcome to the forum.

If I understood well, in complex numbers & Phasors "j" is normally represented by SQRT of -1 .. and Excel has an issue to deal with that for some reason I am not aware of. It throws a number error.

So in this scenario the formula could not be reproduced as far as I am aware, sorry.

Rgds
Rob

 

[aparnaverd]

Hi, welcome to the forum.

If I understood well, in complex numbers & Phasors "j" is normally represented by SQRT of -1 .. and Excel has an issue to deal with that for some reason I am not aware of. It throws a number error.

So in this scenario the formula could not be reproduced as far as I am aware, sorry.

Rgds
Rob

Thank for your reply Rob.