Adding 3D vectors ... need some help...

  • Thread starter Thread starter brandonmatrix2
  • Start date Start date
B

brandonmatrix2

Hey guys -- I am new to this forum, it looks good. Here is my problem:

I have created a worksheet for my AP Physics class where I ask them to
create certain vector parameters and do various things to the created
vectors, such as multiply and add them. But that is not what is
important.

What I need is the following:

To have a cell show the addition of three numbers, with added
coefficients. For example

Cell A1=2.3 A2=3.4 A3=1.2

Cell B2=2.3i+3.4j+1.2k

I want cell B2 to read exactly as the above, without actually adding
the numbers in cells a1 a2 and a3, and I also need those coefficients
to be tacked on.

What do i do?

Thanks guys!
 
In B2 precede the entry with an apostrophe '

'=2.3i+3.4j+1.2k

the apostrophe won't show in the cell all you see is

=2.3i+3.4j+1.2k

that makes sure it is a text string as opposed to a formula
 
Hi

If you want the cell to display using the figures in cells A1, 2 and 3 try
this in B2

=A1&"i+"&A2&"j+"&A3&"k"
or
=CONCATENATE(A1,"i+",A2,"j+",A3,"k")

Andy.
 
thank you for your response, however...

I need B2 to be calculated automatically so that I do not have to enter
the values manually --- meaning, I type the three values into a1 a2 and
a3, and i get a1i+a2j+a3k automatically...
 
Back
Top