• 548K Members
• 7,148 Online
• 655K Conversations

Highlighted
Frequent Visitor

# 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
Highlighted

=INT(D26/K6)
Highlighted

# Re: 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

Highlighted

# Re: How to apply a division formula to display only the Integer (whole number) result?

Plus

= TRUNC( weight / pack )

Highlighted

# Re: How to apply a division formula to display only the Integer (whole number) result?

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.

Highlighted

# Re: How to apply a division formula to display only the Integer (whole number) result?

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.

Related Conversations