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] Decimal Places

More
1 year 7 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
  • Simone's Avatar
1 year 7 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

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

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

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

Moderators: Simonedavid
Time to create page: 0.151 seconds

Cart

Total : 0.00 €