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

Posted on Jul 14, 2025 10:06 AM

Reply
4 replies
Sort By: 

Jul 15, 2025 1:03 AM in response to JP from EG

Your formula is referencing a cell from the row above, cell G5 instead of G6. It is likely that all of the formulas in the column are incorrect and that their results appear correct only because all of the values in G are negative vs being a mix of negative and positive.

Reply

Jul 14, 2025 1:39 PM in response to JP from EG

Which part are you having trouble with?


Are you looking for a textual string that combines the R and X values?


R& " " &IF(X<0,"-j","+j" )& ABS(X)


Where & is the standard symbol for text concatenation to combine multiple fields.


The idea here is that the Z field always starts with the R value and a space, so that's easy:


=R & " "


we then need to check if the X value is positive or negative and adjust accordingly. For that I use an IF() statement:


IF(X<0,"-j","+j" )


This returns either "-j" or "+j' depending on X's value


Then we just append the ABS(X) (we can use ABS since we've already taken care of the positive/negative value)


& ABS(X)




Reply

Jul 14, 2025 11:47 PM in response to Camelot

Yes, that is indeed what I am trying to do. Last night I recognised that I needed some form of conditional statement and the use of the Absolute value of X, but was not sure how to 'concatenate' them.


I have applied your string, and all is fine for the second row onwards. The first row has a blue marker in the top left corner and the wrong 'j' sign.


Strange, but I'm sure you'll know what's going on here.


Thank you


Reply

Expressing complex impedance values in Numbers.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.