multiple price conditions in one formula

Home – SaaS Forums Presale questions Woo Price Calculator multiple price conditions in one formula

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #4549
    jonm
    Participant

    Hello,

    I have a product that the requires height cm x width cm

    Height in CM [aws_price_calc_1]
    Width in CM [aws_price_calc_2]

    ($aws_price_calc_1*$aws_price_calc_2)*0.0028

    Is there a way to have different pricing for certain size brackets? Is it possible to do it with a single formula.

    For example
    between 0-5000 sq cm the pricing would be ($aws_price_calc_1*$aws_price_calc_2)*0.0038
    between 5001-10000 sq cm the pricing would be ($aws_price_calc_1*$aws_price_calc_2)*0.0028
    10000 + sq cm the pricing would be ($aws_price_calc_1*$aws_price_calc_2)*0.0020

    Or, is there a way you can have a base product price of say $25. Then when the min $25 price is reached the formula ($aws_price_calc_1*$aws_price_calc_2)*0.0028 would replace the base pricing

    Hopefully that makes sense 🙂

    Kind Regards,

    Jon

    #4552
    Paul
    Participant

    Hello

    Yes, both are possible using the excel (PRO version WPC). Using some excel formulas as LOOKUP,MATCH,INDEX and IF.
    In regards to your first question you can check this: https://exceljet.net/formula/lookup-value-between-two-numbers
    It shows you how to check a value in a range of numbers.
    In regards to your second question you can solve writing something like : IF((Height*Width)*0.0028>25;(Height*Width)*0.0028;25)

    Let us know if you have more questions.

    Best Regards
    Paul
    AT719

    #4551
    jonm
    Participant

    Many thanks for your response, Paul, greatly appreciated.

    If I purchase the pro version, would you guys be able to supply an initial excell sheet as per the above request? That way I could see how it is setup and hopefully be able to produce my own from thereon.

    Kind Regards,

    Jon

    #4550
    Paul
    Participant

    Hello

    Yes, sure. If you buy the plug-in we can make you an initial excel for you.
    Write us again then when it’s done and send to us the access of your website here: https://altoswebsolutions.com/contact-us
    On the subject add “AT719”

    We will be waiting for your feedback

    Best regards
    Paul
    AT719

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.