Multiplying one known number with fluctuating numbers in cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Georgia - 30 Mar 2008 08:50 GMT

This should be really easy, but I am very elementary with formulas. I can
add and subtract two numbers basically.

Okay, I made a spreadsheet to figure taxes. I need to figure the sales tax
on my gasoline receipts. So I need to multiply .384 by different numbers
(from each receipt) ..... and yes, I'm running late with taxes! :-)

Any help would be appreciated.

Thanks so much.

Reply to this Message

Mike H - 30 Mar 2008 09:36 GMT

Hi let's say the numbers you want to multiply by 0.384 are in column A. Put
0.384 in a Cell (I used C1) and this in B1 and drag down

=A1*$C$1

Mike

> This should be really easy, but I am very elementary with formulas. I can
> add and subtract two numbers basically.
[quoted text clipped - 6 lines]
>
> Thanks so much.

Reply to this Message

Georgia - 31 Mar 2008 03:44 GMT

Thank you so much for your help, I just finished my taxes and I am taking
them in tomorrow! You and God Dibben have been of great help.

Signature

Georgia

> Hi let's say the numbers you want to multiply by 0.384 are in column A. Put
> 0.384 in a Cell (I used C1) and this in B1 and drag down
[quoted text clipped - 13 lines]
> >
> > Thanks so much.

Reply to this Message

Gord Dibben - 30 Mar 2008 17:48 GMT

Enter .384 in a cell, say A1

Enter the numbers from your receipts in a column, say B

In C1 enter =B1*$A$1

Drag/copy down as far as you need.

Note the $ signs to keep A1 Absolute so's it does not change.

Gord Dibben MS Excel MVP

>This should be really easy, but I am very elementary with formulas. I can
>add and subtract two numbers basically.
[quoted text clipped - 6 lines]
>
>Thanks so much.

Reply to this Message

Georgia - 31 Mar 2008 03:46 GMT

Thank you so much for your help, I just finished my taxes and I am taking
them in tomorrow! Thank goodness it's almost over. You and Mike H have been
of great help. (I mispelled your name in the reply to Mike H. Sorry about
that.) Thanks again.

Signature

Georgia

> Enter .384 in a cell, say A1
>
[quoted text clipped - 18 lines]
> >
> >Thanks so much.

Reply to this Message

Gord Dibben - 31 Mar 2008 22:55 GMT

Maybe a misspelling but not a misrepresentation<g>

Thanks for the feedback.

Good luck with the IRS

>Thank you so much for your help, I just finished my taxes and I am taking
>them in tomorrow! Thank goodness it's almost over. You and Mike H have been
>of great help. (I mispelled your name in the reply to Mike H. Sorry about
>that.) Thanks again.

Reply to this Message

Rate this thread: