Microsoft Excell function question

[Guest]

how do I format a D column, so every time I try to multiply cells in a A
column rows and B Columns and C Columns row it will give me the answer in the
D Column rows(ie: I want D1= A1*B1*C1, also D2=A2*B2*C2, as D3=A3*B3*C3)
Please help. Thanks. Robert

 

[Myrna Larson]

You put the formulas you show in cells D1, D2, D3, etc.

 

[Gord Dibben]

In D1 enter =A1*B1*C1

Drag/copy that formula down column D as far as you want/need.

To drag/copy down you would hover the mouse pointer over the bottom right
corner of D1 until you see a black cross appear. Left-click and drag.

Gord Dibben Excel MVP