Thread: My question is about Excel how to create tables by multiplication

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.

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" <BuckeyeBill@discussions.microsoft.com> wrote in message
news:4B565F44-4E8C-40E2-A028-B5E82FEAF735@microsoft.com...
> 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" <BuckeyeBill@discussions.microsoft.com> wrote in message
> news:4B565F44-4E8C-40E2-A028-B5E82FEAF735@microsoft.com...
> > 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" <BuckeyeBill@discussions.microsoft.com> wrote in message
> news:4B565F44-4E8C-40E2-A028-B5E82FEAF735@microsoft.com...
> > 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.
>
>
>