Excel macro to multiply by same value

[Recycler29]

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?

 

[Paul B]

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

 

[Paul B]

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

 

[Recycler29]

Here's my setup:
Col A Col B Col C
Widget $3.00 sold 1, so $3.00
if I sell 2, then $6.00
Any help would be greatly appreciated! Thanks, Kathy

 

[Recycler29]

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

 

[Recycler29]

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]

a second AH HA! I had to change my options back to automatic and it is
working! Thanks for your help Paul! Kathy

 

[Paul B]

Kathy, ooks like you got it working now, your welcome

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