I was trying to write if statements in the formula field as we have some complicated pricing structures, but I found that the if statements don’t work. Can someone help guide me how I can make this work?
We have a client that sells saw blades with different prices based on width/thickness and length of the blades. We have the pricing in an xlsx file, but I cannot get this to work with the import properly. I have attached the pricing sheet created in excel and the inputs sheet has the pricing structure. On the products page however, we are combining the Width and Thickness in to one grouping. The formula is as such:
if(Inches = 0 and Frac_in = 0) THEN (Length * Width_price + Thickness_price)
ELSE(if Inches < 6 THEN ((Length + 0.5) * Width_price + Thickness_price)
ELSE(If Inches = 6 AND Frac_in = 0, ((Length + 0.5)* Width_price + Thickness_price)
ELSE((Length + 1)* Width_price + Thickness_price)
Hopefully someone can help me figure out how this will work with the plugin
We looked at your excel file, but we think we need more information.
Can you send the access to your website to https://altoswebsolutions.com/contact-us ?
We need to see your calculator configuration also.