Forum Discussion
excel pricelist
Your narrative is ambiguous.
I have made a calculation sheet with 7 variables. (length, hight, with, material, coating yes/no, etc. so i can calculate the price of a product.
now i need a list of 50 products with all their own variables.
listed in a tabel with the calculated price at the end.
how can i let excel calculate these 50 products without me having to enter al the variable seperatly for every product???
My understanding of Your narrative:
You have 50 products with their specifications listed in a table and created an equation based on the product specifications which are as follows: (length, height, width, material, coating yes/no, etc.), in the products table.
Your question: How would you convert your equation into an excel formula?
is that an accurate comprehension of your narrative and question?
- Ron_BeudekerSep 17, 2021Copper Contributorcorrect.
- Yea_SoSep 17, 2021Bronze Contributor
- Ron_BeudekerSep 17, 2021Copper Contributorhow can i share it?