Easy Excel Question

  graham√ 09:30 04 Jun 2003
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 2003

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 2003

Thankyou, problem solved.

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

Elsewhere on IDG sites

Huawei MateBook X Pro (2019) review

Magical mystery tour - Artist colourfully customises bus to promote positive mental health

Apple Streaming Service Release Date & Apple TV Subscription Rumours

Quel est le meilleur iPad ?