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?

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?

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?

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" wrote:

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?

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?

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?

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

"Recycler29" wrote:

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?

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

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