Expressing complex impedance values in Numbers.
In Numbers, I want to display the values calculated in two columns, for the Real and Imaginary part of a complex impedance value, in the form Z = R + jX where R and X are two calculated values in the first two columns.
I am unsure how to write the syntax in the 'Z' column to show this. Some examples of the values for R and X are below.
I have tried using @ and "" in the expression, such as = R "j"@X, but that doesn't work. I have also tried various other combinations.
If the value of X is negative, then it needs to show in the Z column as, for example, 26 -j121, otherwise, with an example of a positive value of X, then it would show as 26 +j68
I hope someone can help.
Thanks
Julian
Mac mini, macOS 13.7