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

Ron_Beudeker 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_Beudeker You'll have to share the equation and the product table if you need help in converting

Ron_Beudeker when you click reply this will come up:click open full text editor, then this will come up:click browse to attach workbook

excel pricelist | Microsoft Community Hub

10 Replies

Yea_So
Bronze Contributor
Sep 17, 2021
Ron_Beudeker
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_Beudeker
  Copper Contributor
  Sep 17, 2021
  correct.
  - Yea_So
    Bronze Contributor
    Sep 17, 2021
    Ron_Beudeker
    
    You'll have to share the equation and the product table if you need help in converting

Forum Discussion

excel pricelist

10 Replies

Resources