Forum Discussion
Assign € value to text excel
Good morning!
I could really use your help!
I need to create a CSV file containing all possible articles: combinations + prices to upload to my website. This concerns 10,000th articles. I have already included all combinations in this list, but now the prices still have to be added here. Each cell (text) has a specific value. Let's say: Bicycle shelter 1500mm has a standard price of: € 500 /// possible options: surcharge coated version: € 250 /// + surcharge including waste bin 50 € /// surcharge LED light: € 150 ///
Is it possible to give the text cells a value:
Bicycle shelter 1500mm = €500
Coated version = €250
Waste bin = € 50,-
LED light = € 150
If so, I can release a formula in the Excel sheet so that it calculates the total price of the shelter by itself.
My customer can put together the desired shelter on my website. after which a total price is displayed.
Below a screenshot from the sheet. Hope it is clear and thanks in advance for your help!!
Kind regards,
Nynke de Jong