Conditional statements in spreadsheet…..

Home – SaaS Forums Support questions WooPrice Calculator (Pro) Conditional statements in spreadsheet…..

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #6625
    Jordan McBain
    Participant

    I’ve created a spreadsheet for price calculation. It works in excel, but not in the price calculator.

    I am using conditional statements to change my prices. Currently for business cards cost is set by quantity

    100 – $11.99
    250- $12.99
    500 – $13.99
    and so on…

    Now for 2 sided cards it adds a set amount dependent on the quantity

    100 +$0
    250 +$0
    500 +$3.99
    1000 + $4.99
    and so one

    This goes on with other variations as well. I have set up a formula in excel with IF statements to calculate this. Do these statements not translate into this plugin. Is there an alternative?

    I have attached my spreadsheet. The sheet marked Economy is the one I am working on

    Thanks for any help

    #6630
    Anonymous
    Guest

    Hi Jordan,

    usually there is no issue using IF function.
    I’m not pretty sure your formula is completely correct. When I open file after saving i get error in C5 cell.
    I updated your Excel Sheet using INDEX and MATCH functions. It helps me to understand better all datas.
    Anyway it’s still not working well, we’re fixing it.
    [attachment=25]Prices-index-match.xls[/attachment]
    I’m going to inform you as soon as it will be ok.

    Regards,
    Simone

    #6629
    Jordan McBain
    Participant

    How is this coming along?

    #6628
    Anonymous
    Guest

    Hi Jordan,

    we’re working on it, I hope to give you some news within tomorrow.

    Regards,
    Simone

    #6627
    Anonymous
    Guest

    Hi Jordan,

    sorry for delay, we found now the reason why it didn’t work.
    On first we noticed that after saving your file Prices.xls and closing-reopening it, the cell C5 had an error “#VALUE!” and your formula with IF function disappeared.
    So we tried to get the same result using INDEX and MATCH functions but we still had problem after uploading in WPC PRO.
    We solved both issue by saving Excel Sheets on [b]XLSX[/b] format instead of XLS format.
    I attach both files we used to test it.
    [attachment=31]Prices.xlsx[/attachment] [attachment=30]Prices-index-match.xlsx[/attachment]

    Regards,
    Simone

    #6626
    Robert Becerra
    Participant

    Hi Jordan can You show me how this calculator works. i have the same business and I’m just trying to set myself apart the other printers in town. but i can’t seem to understand the conditional statement set up.

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