A1 has number 2 in it, A3 has number 3 in it, How do i multiply A2 by A3 and put the answer in A4

Copper Contributor

A1 has number 2 in it, A3 has number 3 in it, How do i multiply A2 by A3 and put the answer in A4

3 Replies

@McvitieBiscuits1909 

Did you mean to write "A2 has number 2 in it"?

If so, enter the following formula in A4:  =A2*A3

@Hans Vogelaar 

Thank you, I had to put the 2 cells in comma's  =SUM(E159*E160) this did the trick as E159 was already a sum of the above cell, cheers

@McvitieBiscuits1909 

You don't need the SUM function here.

=E159*E160

is equivalent to

=SUM(E159*E160)

but shorter and simpler.