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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - set up formula so every entry in Row A and Row B will be multipli. (https://www.excelbanter.com/excel-discussion-misc-queries/11094-set-up-formula-so-every-entry-row-row-b-will-multipli.html)

xinti

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

Row A multiplied by Row B will result in the answer in Row C

Bob Phillips

A3: =A1*A2

and copy across

--

HTH

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

"xinti" wrote in message
...
Row A multiplied by Row B will result in the answer in Row C

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

On Tue, 1 Feb 2005 21:29:06 -0800, "xinti"
wrote:

Row A multiplied by Row B will result in the answer in Row C

All times are GMT +1. The time now is 02:46 AM.