Total : 0.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

Conditional statements in spreadsheet.....

More
1 year 4 months ago #455 by Robert Becerra
Robert Becerra replied the topic: Conditional statements in spreadsheet.....
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.

Please Log in or Create an account to join the conversation.

  • Simone
  • Simone's Avatar
1 year 9 months ago - 1 year 9 months ago #83 by Simone
Simone replied the topic: Conditional statements in spreadsheet.....
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 XLSX format instead of XLS format.
I attach both files we used to test it.

File Attachment:

File Name: Prices.xlsx
File Size:7 KB

File Attachment:

File Name: Prices-ind...tch.xlsx
File Size:9 KB


Regards,
Simone
Attachments:
Last Edit: 1 year 9 months ago by Simone.

Please Log in or Create an account to join the conversation.

  • Simone
  • Simone's Avatar
1 year 9 months ago #70 by Simone
Simone replied the topic: Conditional statements in spreadsheet.....
Hi Jordan,

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

Regards,
Simone

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #69 by Jordan McBain
Jordan McBain replied the topic: Conditional statements in spreadsheet.....
How is this coming along?

Please Log in or Create an account to join the conversation.

  • Simone
  • Simone's Avatar
1 year 10 months ago - 1 year 10 months ago #65 by Simone
Simone replied the topic: Conditional statements in spreadsheet.....
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.

File Attachment:

File Name: Prices-ind...atch.xls
File Size:22 KB

I'm going to inform you as soon as it will be ok.

Regards,
Simone
Attachments:
Last Edit: 1 year 10 months ago by Simone.

Please Log in or Create an account to join the conversation.

More
1 year 10 months ago - 1 year 10 months ago #54 by Jordan McBain
Jordan McBain created the topic: Conditional statements in spreadsheet.....
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
Attachments:
Last Edit: 1 year 10 months ago by Jordan McBain.

Please Log in or Create an account to join the conversation.

Moderators: Simonedavid
Time to create page: 0.188 seconds

Cart

Total : 0.00 €