Hit enter to fast, and fill the formula down as far as needed, if you don't
want the 0's to show for the rows that you don't have date in column C you
something like this =IF(ISBLANK(C1),"",B1*C1) and copy down

--
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

"Paul B" wrote in message
...
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?