Multiplying changing cell by a fixed cell.

[Ski]

Hello,

I have a formula where Microsoft Excel multiplies cell A3 by cell C1 and
drop the result into C3 (see below).


A B C
1 2%
2
3 $100 $2.00



The formula I use in cell C3 is as follows: =SUM(A3*C1).

The issue I am having is that when I copy the formula in cell C3 down to
cell C4... Excel correctly assumes I want to use the input of cell A4
but INCORRECTLY assumes I want to use the value in cell C2 (see below).



A B C
1 2%
2
3 $100 $2.00
4 $101 $0.00



What I would like to have happen is to get Excel to use values found in
the A column and then ALWAYS multiply them by the value in cell C1,
dropping the result in the C column like this:


A B C
1 2%
2
3 $100 $2.00
4 $101 $2.02


The formula =sum([cell A-whatever]*C1) will not work, but I do not know
what will.

Would anyone please let me know the correct formula or point me toward a
FAQ or some such which would explain how to write the formula? I tried
looking this up via Google, but I don't even know the terms to input
into Google to perform such a search.

Thankfully,

Ski

 

[Allen Laptop]

Put a dollar sign in front of the cell you want frozen Then the cell number
will not change when you copy another