Forum Discussion
New here...Looking forward to solving my questions with your help. Question #1
Hi All,
I work at a company that does custom fabrication using various type of plastic sheets, acrylic, ABS, PolyCarbonate,...etc. I am creating a form for our counter staff to use to calculate easily, pricing based on number of pcs, size of pcs, thickness of pcs and price per square foot for the material type chosen. I have input cells for the sales person to input quantity, size, type and thickness of plastic. Everything from there will auto calculate. I have Option buttons referencing prices per square for the material. which I have on sheet 2. I have grouped the buttons based on thickness for every type of material. I select an option button for the material type, another for the thickness, and price will calculate using a total square footage calculated. See file. I would like to know if there is a simplified way or formula to calculate all my answers needed to get my "Total Price"? The file is a small sample I've put together to figure things out.
Thank you,
Jeff
Hello,
the formula can be a lot shorter if you use the INDEX() function to get the rate. The syntax of index is
=Index(table,row number, column number)
In your case you can use
=INDEX(B12:D14,C9,F9)
and then multiply with the value for SQ.Ft
=INDEX(B12:D14,C9,F9)*I2
Hello,
the formula can be a lot shorter if you use the INDEX() function to get the rate. The syntax of index is
=Index(table,row number, column number)
In your case you can use
=INDEX(B12:D14,C9,F9)
and then multiply with the value for SQ.Ft
=INDEX(B12:D14,C9,F9)*I2
Hi there,
Thank you for your reply. Is this replacing the formula in cell K11?
Ok, I just tried your suggestion. WOW!!! I owe you a nice bottle of wine. Thank you so much. You've made my day.
Cheers,
Jeff
- Ok, I just tried your suggestion. WOW!!! I owe you a nice bottle of wine. Thank you so much. You've made my day.
Cheers,
JeffThanks for the feedback. Glad it helped.
