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

More
1 year 2 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,

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

More
1 year 2 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
The following user(s) said Thank You: Gusti Ngurah

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

More
1 year 2 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?

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

More
1 year 2 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 "hello@woopricecalculator.com" or attach it here if you prefer.

Best regards,
Enrico

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

More
1 year 2 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 :(

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

Moderators: david
Time to create page: 0.167 seconds

Cart

Total : 0.00 €