Total : 24.00 €

Before contacting us, please make sure to check our F.A.Q

Please, login or register to our website in order to be able to post a presale question in the forum.

× WooPrice Calculator PRO

# [SOLVED] If statements

1 year 5 months ago #1624 by Paul
Paul replied the topic: If statements
Hello,

okay, good to know.
anyway, don't hesitate to write in forum any question you have.

Best Regards,
Paul
AT533

1 year 6 months ago #1623 by Tyler Robinson
Tyler Robinson replied the topic: If statements
I had a meeting with the client and we came up with a better way to calculate their pricing and eliminate unnecessary options. I believe I have found a better way to accomplish what we need.

Thanks!

1 year 6 months ago #1622 by Paul
Paul replied the topic: If statements
Hello,

We need to see your calculator configuration also.

We will be waiting for your feedback.

Best Regards
Paul
AT533

1 year 6 months ago - 1 year 6 months ago #1619 by Tyler Robinson
Tyler Robinson created the topic: If statements
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
##### Attachments:
Last Edit: 1 year 6 months ago by Tyler Robinson.

Moderators: david
Time to create page: 0.157 seconds

Total : 24.00 €