Easy Excel Question

  graham√ 09:30 04 Jun 03
Locked

How do I multiply the contents of column A by, say, 2, to give the results in column B.

  scotty 09:39 04 Jun 03

In cell B1, insert the function PRODUCT e.g.

=PRODUCT(A1,$E$1)

Cell E1 should contain the multiplier. Click on cell B1 then drag the square at the bottom right of the box to put this formula in other cells in row B.

  graham√ 09:57 04 Jun 03

Thankyou, problem solved.

  GroupFC 10:00 04 Jun 03

In cell B1 just put =A1*2 (or whatever other multiplier you wish to use.

This really was an easy question or have I missed something here!!!

Regards

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…