Ah HA! I had to correct the references! I was on line 3 instead of line 1.
sorry! However, the formula works fhen I'm setting it up but I wanted to
change the number sold and the formula is not changing when I change the
value in column C. Any ideas? Kathy

"Recycler29" wrote:

Hi Paul, yes, I was putting the number sold in Column C. I tried to put the
formulas you suggested in Column D; both examples and nothing is happening!?
Any ideas on what I'm doing wrong?
A B C D
widget $3.00 1 0

I wanted Column D to multiply b and C together but it shows a 0 when I'm
wanting $3.00. Thanks for helping me, Kathy

"Paul B" wrote:

recycler29, are you putting the amount sold in a cell? if you put it in
column C you could put a formula in column D like this =B1*C1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Recycler29" wrote in message
...
I am trying to setup an Excel spreadsheet with Column A containing several
items. Column B has a list of each cost for Column A. If I were to sell
the
item in ColumnA, Row 1, at the cost in Column B, Row 1, how can I get the
value in Colum C, Row 1, to reflect how much I've sold? Say the cost is
$3.00. If I sell one, I would want Column C, Row 1 to read $3.00. If I
sold
2, I want it to change to $6.00. Is this possible?