Excel / decimals after the decimal point
Solved
PéPé2Nim
Posted messages
10
Status
Membre
-
HBO -
HBO -
Hello,
I have a pricing grid with sometimes 2, sometimes 3, and sometimes 4 digits after the decimal point.
Thanks to the "Reduce Decimals" option in the menu bar, I can display numbers with two decimal places
but inside the cells, the numbers still retain all their decimal places
Is there a function that would allow me to actually reduce all the numbers to 2 decimal places?
This way, when multiplying, we should end up with correct results
Example of a displayed result after using the "Reduce Decimals" option
1.55 * 150 = 233.10
This result is incorrect because the actual number in the cell is: 1.554
1.554 * 150 = 233.10
The result I would like to obtain is the following: 1.55 * 150 = 232.50
The table is large and filled with numbers
my problem is finding an automatic way to reduce the decimals without changing the prices manually
Thank you in advance for your help
PéPé2Nim
I have a pricing grid with sometimes 2, sometimes 3, and sometimes 4 digits after the decimal point.
Thanks to the "Reduce Decimals" option in the menu bar, I can display numbers with two decimal places
but inside the cells, the numbers still retain all their decimal places
Is there a function that would allow me to actually reduce all the numbers to 2 decimal places?
This way, when multiplying, we should end up with correct results
Example of a displayed result after using the "Reduce Decimals" option
1.55 * 150 = 233.10
This result is incorrect because the actual number in the cell is: 1.554
1.554 * 150 = 233.10
The result I would like to obtain is the following: 1.55 * 150 = 232.50
The table is large and filled with numbers
my problem is finding an automatic way to reduce the decimals without changing the prices manually
Thank you in advance for your help
PéPé2Nim
Configuration: Windows XP Firefox 3.0.12
=FLOOR(Nb/0.01)*0.01
Nb = number to round
0.01 for 2 digits after the decimal point.
To round to the nearest hundredth, you can use this formula:
=ROUND(Nb, 2)
Nb = number to round
0.001 and +0.05 for 3 digits after the decimal point.
etc...