Anyone that understands Microsoft Excel, please help...?

Question

I haven't used Excel in years and I've totally forgotten how to do this. What do I put in the "fx" line or how do I type in the formula if I want, for example
Column A line 3 is 2.99
Column B line 3 is 12% of Column A
Column C line 3 is 7% of Column A, and
Column D line 3 is the total of A, B & C and then this would continue on the next line but with a different starting figure.
Eg.
----------------A------B-----C-----D
First line:-- 2.99 0.36 0.21 $3.56
Second:--- 3.99 0.48 0.28 $4.75
Third:------- 4.99 0.60 0.35 $5.94
Does anyone know how the formula goes????

Your answers have been extremely helpful, but how can I limit the numbers to only be, for example 0.36 as opposed to 0.3588?

Never mind, I can just use the $ to get the figure I want!

Answer 1

in your worksheet, go to cell A3 and type 2.99
In cell B3 type =A3*12%
In cell C3 type =A3*7%
In cell D3 type =A3+B3+C3
---
Then continue filling in new numbers in colum A. When you're done, copy and paste the formulas as follows:
Drag and select the mouse over cells B3 through D3. Hit Ctrl+C
Then drag and select the mouse over cells B4, all the way down column B untill you're next to the last number in column A. Hit Ctrl+V

Answer 2

Here are the formulas:

Column B, line 3 (remove the quotes): "=A3*.12"
Column C, line 3: "=A3*.07"
Column D, line 3: "=SUM(A3:C3)"

Line 4 would be the same as line 3, but replace the "3" with a "4".

Good luck.

Answer 3

Once you enter the formulas in B3, C3, and D3 (denoted B3:D3), you can select B3:D3 and point to the fill handle (the lower right corner of the selected range) and drag it down thru the desired range. The formula will change relative to its movement (relative referencing).

To display only 2 decimal points: Select the cell (or range) that you wish to change and click Format (on the menu bar), click Cells..., and click the Number tab. Click Currency. Notice that here you can set the number of decimal places to display and whether or not to display the $ sign. Click OK.

Answer 4

Enter value in column A (for example cell A1)
in B1, the formula is =A1*.12
In C1 the formula is =A1*.07
in D1 the formula is =SUM(A1:C1)

You can copy this down to other rows as far as you need to.

Answer 5

Ok for A3(or whatever cell you are on) just type in your value, then for B3(or whatever cell you are on) type =A3*.12 (substitute in whatever A cell you are using). Then for C3 type =A3*.07 (substitute in whatever A cell you are using.) Then for D3 (or whatever cell you are on) hit the AutoSum button OR type in =SUM(A3:C3) (substitute in whatever cells you were using) hope this helps

Answer 6

B1= +(A1*0.12)
C1= +(A1*0.07)
D1= +A+B+C

You can then copy these cells and select the epty cells below and select Edit->Paste Special and then check the Formulas box.

Answer 7

What's Microsoft Excel?
What's Microsoft?
Who am i...