Forum Discussion
How to apply a division formula to display only the Integer (whole number) result?
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.
Peter,
IMHO, FLOOR works with negative numbers and MROUND not. But with both you may receive floating point error if second parameter is not integer.