When you make invoices or bills in Excel, you often get numbers with decimals — like 12.85 litres or 250.75 rupees.
But in most invoices, we only need whole numbers like 250.
For this, Excel gives a simple function — INT — that rounds any number down to the nearest whole number (integer).
What Is the INT Function?
The INT function (short for Integer) removes the decimal part of a number and gives only the whole number below it.
It always rounds down, no matter what the decimal value is.
It’s a simple way to remove decimals when you want to deal only with full units.
Syntax
INT(number)
number –The value you want to round down.
How It Works?
| Formula | Result | Explanation |
| =INT(4.9) | 4 | Rounds down to 4 |
| =INT(7.2) | 7 | Removes the decimal |
| =INT(9.999) | 9 | Always goes down |
| =INT(-4.3) | -5 | Goes to the next lower integer |
The INT function always rounds down.
Even for negative numbers, Excel rounds downward (away from zero).
So, -4.3 becomes -5 not -4, because -5 is smaller.
How It Helps in Invoices?
The INT function is very useful when creating milk delivery, transport, or product invoices in Excel.
It helps you to:
- Remove unnecessary decimal values from litres, kgs, or units.
- Avoid messy decimal values in totals.
- Keep invoice totals simple and easy to read.
- Avoid overbilling when fractional values appear in calculations.
Example:
If you calculate total litres as `=A2B2` and get 5.27,
use `=INT(A2B2)` to show 5 litres only in your invoice.
INT vs ROUND vs ROUNDDOWN:
| Function | What It Does | Example | Result |
| INT | Always rounds down to whole number | =INT(4.8) | 4 |
| ROUND | Rounds up or down normally | =ROUND(4.8,0) | 5 |
| ROUNDDOWN | Rounds down to chosen decimals | =ROUNDDOWN(4.86,1) | 4.8 |
- INT is the simplest choice when you want only whole numbers.
- Use ROUNDDOWN if you need to round down but still keep some decimals.
The INT function in Excel:
- Removes decimal part completely
- Always rounds down
- Makes invoice and quantity data clean
- Displaying only full units neatly
Using INT() makes your Excel sheets clean, professional, and accurate — just what every invoice needs.
Discover more from Excellopedia
Subscribe to get the latest posts sent to your email.