- Posts: 12
- Thank you received: 1
×
WooPrice Calculator PRO
[SOLVED] Decimal Places
- PG
-
Topic Author
- Offline
Less
More
3 years 11 months ago #127
by PG
PG replied the topic: [SOLVED] Decimal Places
Ah okay thanks, as long as it won't affect quantity pricing.
Please Log in or Create an account to join the conversation.
- Simone
-
3 years 11 months ago #121
by Simone
Simone replied the topic: [SOLVED] Decimal Places
Hi PG,
when you import a sheet on WPC it see al decimals he used to get your price.
Also if you set 2 decimal on Excel cell, you know that it's just for human eyes, it's not a ROUND.
Excel still consider all decimals to make perfect calculations, so this is the reason why you see sometimes decimals when you map it.
It depend by sheet calculations.
So it shouldn't affect your output price.
Additionally you could insert a ROUND function to output in order to round the price as you want.
Regards,
Simone
when you import a sheet on WPC it see al decimals he used to get your price.
Also if you set 2 decimal on Excel cell, you know that it's just for human eyes, it's not a ROUND.
Excel still consider all decimals to make perfect calculations, so this is the reason why you see sometimes decimals when you map it.
It depend by sheet calculations.
So it shouldn't affect your output price.
Additionally you could insert a ROUND function to output in order to round the price as you want.
Regards,
Simone
Please Log in or Create an account to join the conversation.
- PG
-
Topic Author
- Offline
Less
More
- Posts: 12
- Thank you received: 1
3 years 11 months ago #115
by PG
PG created the topic: [SOLVED] Decimal Places
Hi, sometimes the Excel decimal places setting is ignored? I have a sheet where all prices are number format with 2 decimal places. When it's imported into WPC Pro it shows about 15 decimal places in the mapping screen on some values. It's a worry because it can affect the price of an order depending on the quantity. It's a basic clean spreadsheet where all cells are either general (for text) or number inc. 2 decimal places (for prices) format.
If you want one of our Excel sheets let us know, or a screenshot of the Mapping page.
Thanks
If you want one of our Excel sheets let us know, or a screenshot of the Mapping page.
Thanks

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