Alberto Excel
New Member
- Joined
- Jul 2, 2012
- Messages
- 3
Dear All,
I am trying to create a quotation where I multiply my costs to different values depending on where the merchandise comes from, using Excel 2010.
In the first column I would put my cost price.
In the second column I would put the country of provenance. I.E. A for America, E for Europe, and C for China.
In three separate cells I would put the multiplying coefficient for each region. I.E. American prices would be multiplied by 2, European by 2.5, and Chinese by 1.7
I would like to create a formula where if in the column of provenance there is i.e. E (for Europe,) the cost in the first column would be multiplied by 2.5, and so on and so forth for each value in each cell of the first column.
Does anybody have any idea how to do this? I would be very grateful for any suggestions. Thanks!
Please also understand my knowledge of Excel is limited and I may be ignorant of other options available to solve this problem.
I am trying to create a quotation where I multiply my costs to different values depending on where the merchandise comes from, using Excel 2010.
In the first column I would put my cost price.
In the second column I would put the country of provenance. I.E. A for America, E for Europe, and C for China.
In three separate cells I would put the multiplying coefficient for each region. I.E. American prices would be multiplied by 2, European by 2.5, and Chinese by 1.7
I would like to create a formula where if in the column of provenance there is i.e. E (for Europe,) the cost in the first column would be multiplied by 2.5, and so on and so forth for each value in each cell of the first column.
Does anybody have any idea how to do this? I would be very grateful for any suggestions. Thanks!
Please also understand my knowledge of Excel is limited and I may be ignorant of other options available to solve this problem.
Glad I could help 
Appreciate the feedback!
