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.