My question is about Excel how to create tables by multiplication

B

BuckeyeBill

I'm interested in how to build a table that uses cell multiplication.
For example; if you create a row that that reflected hourly wages of
$10, $12, $14, $16, $18, $20 and the column to multiply by
represented worked hours i.e. 20 hours, 25 hours, 30 hours, 25 hours and
40 hours --- what is the easiest way to set up the cell calculation so that
it would populate each cell vice manually working through each cell with
=A4*B2, then moving to the next cell. Thanks in advance for any thoughts
you might have regarding this question.
 
B

Bernard Liengme

Sounds like homework but here goes
With hourly rates in row 2 starting in B2, Hours in column A starting in row
4
In B4 enter =A4*B2 but this cannot be copied since the formula will change.
You need the 2 in B in B2 to be constant and the A in A4 to not change,
so use =B$2*$A4
best wishes
 
J

Jonathan Cooper

Assuming your wage rates go from A2:A7, and that your hours go from B1:F1.

Your forumla in B2 is:

=$A2*B$1
 
B

BuckeyeBill

Thanks for your help.


Jonathan Cooper said:
Assuming your wage rates go from A2:A7, and that your hours go from B1:F1.

Your forumla in B2 is:

=$A2*B$1
Click to expand...
 
B

BuckeyeBill

Thanks. No,it wasn't homework. But
you wouldn't believe how many textbooks
I've "thumbed through" trying to find an
answer. Thanks again.
 
Top