Forum Discussion
Solved
How to calculate nearest value without decimals
I want to have a formula which enables me to get an optimal M2 calculation. Example: a product has the following dimensions: 396mm x 579mm. How many pieces result in .000 decimals? In this case 1,24...
AKlompOoops! I was wrong here. One product measures just under 23 m2. Not just over 229 m2. Correct? Now you want to find a factor that multiplies the exact size of the product so that the last three digits of the integer are all zeroes. Correct?
If the 229284 is in A1, try this formula is you are on MS365 or 2021.
=1+(MATCH(0,MOD(INT(A1*SEQUENCE(1000,,1,0.001)),1000),0)-1)/1000
This will return 1.243
Hi,
To take only the nearest value without decimals use rounddown() function
=ROUNDDOWN(A1,0)
0 --> mean no decimals,
To take only the nearest value without decimals use rounddown() function
=ROUNDDOWN(A1,0)
0 --> mean no decimals,