Vector addition... need help on how

[Ralph2]

Hello
As part of a project I need to vectorially add 12 values

On searching the WWW there are numerous Java based samples... Can
anyone advise (or provide) a sample of how I can accomplish this in MS
Excel

Thanks for any help or direction
Ralph

 

[Bucky]

As part of a project I need to vectorially add 12 values

Should be easy. Have 2 columns represent magnitude and angle. Have 2
more columns i and j.

i = mag * COS(RADIANS(angle))
j = mag * SIN(RADIANS(angle))

Sum i and j and convert back to magnitude and angle.