Forum Discussion
How to apply a division formula to display only the Integer (whole number) result?
How do I apply a formula and/or formatting to display only the integer result when both the input fields have decimal values.
See my attached file -
1. Cell D28 = the result of Cell D26 / Cell K6 - (9,85Kg / 0,5Kg) = only 19 and not 19,7 (as the 0,7 represents only 70% of the following pack unit of 500gr
Cell D28 should only display the integer = 19
See attached file
5 Replies
Just so that you have choice;
= INT( weight / pack )
= QUOTIENT( weight, pack )
= FLOOR( weight, pack ) / pack
True. Once one starts looking, there appears to be a bewildering number of options! I could add
= ROUNDDOWN(weight/pack, 0)
= MROUND( weight, pack ) / pack
Not that I can see any difference between the MROUND and FLOOR functions.
The OP can be interpreted not so much as 'how can I perform the calculation?' as 'which, of all the options, is the clearest?'.
I would favour one of these last two functions because the intent of each step of the calculation is clear but I could also go with INT on the grounds that it is the most basic function that will do the job.
- =INT(D26/K6)
