set up formula so every entry in Row A and Row B will be multipli.

B

Bob Phillips

A3: =A1*A2

and copy across

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
G

Gord Dibben

A and B are not rows, they are columns.

1,2,3 etc are rows.

Do you mean =A1 * B1 entered in C1 and drag/copy down column C?


Gord Dibben Excel MVP
 
Top