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

# [SOLVED] Price Round Up

3 years 4 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,

3 years 4 months ago #348 by Enrico
Enrico replied the topic: [SOLVED] Price Round Up
Hi Gusti,

I see that the formula you wrote is quite complex.

Best regards,
Enrico
The following user(s) said Thank You: Gusti Ngurah

3 years 4 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

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?
##### Attachments:

3 years 4 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

3 years 4 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)