- Posts: 6
- Thank you received: 0
×
WooPrice Calculator PRO
[SOLVED] Price Round Up
- Gusti Ngurah
-
Topic Author
- Offline
Less
More
3 years 8 months ago #349
by Gusti Ngurah
Gusti Ngurah replied the topic: [SOLVED] Price Round Up
Omg, thanks so much. Tried the load calculator thing, worked like a charm. I'm so used with working with excel so I think it's faster to just type the formula directly. Much appreciated, Enrico.
Best regards,
Best regards,
Please Log in or Create an account to join the conversation.
- Enrico
-
- Offline
Less
More
- Posts: 367
- Thank you received: 18
3 years 8 months ago #348
by Enrico
Enrico replied the topic: [SOLVED] Price Round Up
Hi Gusti,
Why don't you upload your Excel spreadsheet directly instead of writing the formula?
I see that the formula you wrote is quite complex.
Best regards,
Enrico
Why don't you upload your Excel spreadsheet directly instead of writing the formula?
I see that the formula you wrote is quite complex.
Best regards,
Enrico
The following user(s) said Thank You: Gusti Ngurah
Please Log in or Create an account to join the conversation.
- Gusti Ngurah
-
Topic Author
- Offline
Less
More
- Posts: 6
- Thank you received: 0
3 years 8 months ago #347
by Gusti Ngurah
Gusti Ngurah replied the topic: [SOLVED] Price Round Up
Hi. Yeah so I've been trying to do it like in the attached pics.
In my case, i expect :
price = 1.120.000
multiple of = 50.000
result price = 1.150.000
Instead, i got :
price = 1.120.000
multiple of = 50.000
result price = 50.000 (the multiple)
I try to do the same thing with excel just to make sure the formula is correct (see : test formula with excel.jpeg). Assuming the formula to use in the plugin is the same in excel, it should work, but i'm not sure. Is there anything I'm doing wrong here?
In my case, i expect :
price = 1.120.000
multiple of = 50.000
result price = 1.150.000
Instead, i got :
price = 1.120.000
multiple of = 50.000
result price = 50.000 (the multiple)
I try to do the same thing with excel just to make sure the formula is correct (see : test formula with excel.jpeg). Assuming the formula to use in the plugin is the same in excel, it should work, but i'm not sure. Is there anything I'm doing wrong here?
Please Log in or Create an account to join the conversation.
- Enrico
-
- Offline
Less
More
- Posts: 367
- Thank you received: 18
3 years 8 months ago #346
by Enrico
Enrico replied the topic: [SOLVED] Price Round Up
Hi Gusti,
Can you send the Excel spreadsheet that is not working to " altoswebsolutions.com/contact-us " or attach it here if you prefer.
Best regards,
Enrico
Can you send the Excel spreadsheet that is not working to " altoswebsolutions.com/contact-us " or attach it here if you prefer.
Best regards,
Enrico
Please Log in or Create an account to join the conversation.
- Gusti Ngurah
-
Topic Author
- Offline
Less
More
- Posts: 6
- Thank you received: 0
3 years 8 months ago #345
by Gusti Ngurah
Gusti Ngurah created the topic: [SOLVED] Price Round Up
Hi, I wonder if you can round up price just like in excel. In excel you can round up price with 'ceiling' function.
Example : price $473, round up to the nearest multiple of $10, hence price 480$.
I've been trying to do this with the same way as in excel, but still no luck. FYI the formula in excel goes like this =CEILING(number, multiple)
Is there anyway I can do this? Please help
Example : price $473, round up to the nearest multiple of $10, hence price 480$.
I've been trying to do this with the same way as in excel, but still no luck. FYI the formula in excel goes like this =CEILING(number, multiple)
Is there anyway I can do this? Please help

Please Log in or Create an account to join the conversation.
Moderators: david
Time to create page: 0.156 seconds