ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Matrix with imaginary numbers (https://www.excelbanter.com/new-users-excel/112703-matrix-imaginary-numbers.html)

CGA

Matrix with imaginary numbers
 
I am trying to do a matrix that has real and imaginary numbers and I have no
clue how to do it. I can do a matrix with real numbers, but apparently can't
with the combination of both.

venkat

Matrix with imaginary numbers
 
in a2 enter a formuala
=randbetween(1,10) and copy down.
as thes are randomedit number they may change time to time so you copy the
column A and highlight A1 edit pastespecial-values
similarly formula in B2 is
=randbetween(-5,5) and copy down and copy with pastespecial values
in C2 type
=complex(a2,B2) and copy down.

you get some sort of random compled numbers.






"CGA" wrote:

I am trying to do a matrix that has real and imaginary numbers and I have no
clue how to do it. I can do a matrix with real numbers, but apparently can't
with the combination of both.



All times are GMT +1. The time now is 08:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com