When I sell an item, I want the cost to appear in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I sell cellphones; A, B, C. A costs 5.00, B costs 10.00 and C costs 20.00. If I have columns labeled "Type of Cellphone" and "Cost", I wnat to be able to enter the Type of Cellphone and a Cost appear. I currently have a dropdown for "Type of Cellphone with A,B, and C, but now I am stuck. Any help would be greatly appreciated.
 
rallen122 said:
I sell cellphones; A, B, C. A costs 5.00, B costs 10.00 and C costs 20.00.
Click to expand...

You do?
the Type of Cellphone and a Cost appear. I currently have a dropdown for
Click to expand...
"Type of Cellphone with A,B, and C, but now I am stuck. Any help would be
greatly >appreciated.

Since you only have 3 options, you can do an if formula
IF(A1="A",5,IF(A1="B",10,IF(.... etc.

Or you can make a table somewhere, like
A 5
B 10
C 20

then use VLOOKUP (see help or other newsgroup posts for examples).

Easiest thing I think would be to rename cellphones A B C to 1 2 3 , and use
CHOOSE(cellphone number,5,10,20)
 
You should investigate VLOOKUP

Assuming you have a worksheet (CellPhones) with the phone names in column A
and the prices in column B, you could use this formula:

=IF(ISNA(VLOOKUP(A2,CellPhones!A:B,2,FALSE)),
"Invalid",VLOOKUP(A2,CellPhones!A:B,2,FALSE))

Regards

Trevor


rallen122 said:
I sell cellphones; A, B, C. A costs 5.00, B costs 10.00 and C costs 20.00.
Click to expand...
If I have columns labeled "Type of Cellphone" and "Cost", I wnat to be
able to enter the Type of Cellphone and a Cost appear. I currently have a
dropdown for "Type of Cellphone with A,B, and C, but now I am stuck. Any
help would be greatly appreciated.
 
Back
Top