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.

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"BuckeyeBill" wrote in message
...
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.

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

Your forumla in B2 is:

=$A2*B$1


"BuckeyeBill" wrote:

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.

Thanks for your help.


"Jonathan Cooper" wrote:

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

Your forumla in B2 is:

=$A2*B$1


"BuckeyeBill" wrote:

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.

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.

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"BuckeyeBill" wrote in message
...
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.