How to Convert INR Salary Amounts to Lakhs in Excel
Question details
The user needs to convert large Indian Rupee (INR) salary figures into a decimal format representing 'lakhs' (hundred thousands).
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Formatting and calculating regional currency figures (Indian Rupees) for reporting, making large salary amounts easier to read by expressing them in lakhs.
- Observed behavior
- The goal is to divide the raw salary amount by 100,000 and round it down to exactly two decimal places, so a figure like 1,760,200 becomes 17.60.
Ensure your salary data is formatted as standard numbers or currency, without any hidden text characters, so the calculation formula works correctly.
Use the ROUNDDOWN Function to Convert to Lakhs
This is the most accurate method to convert large numbers into lakhs with exact two-decimal precision, ensuring the value is not accidentally rounded up.
The ROUNDDOWN function in Excel forces a number to round towards zero. By dividing your salary amount by 100,000, you scale it to lakhs. Using ROUNDDOWN with a precision of 2 ensures that you always get an exact cutoff without the mathematical rounding up that standard formatting might apply.
Click on the empty cell next to your first salary amount (for example, cell B2 if your salary data is in A2).
Type the formula =ROUNDDOWN(A2/100000, 2) into the formula bar and press Enter.
Click on cell B2 again, grab the small square handle at the bottom-right corner of the cell, and drag it down to fill the formula for all your salary amounts.
Use the TRUNC Function as an Alternative
The TRUNC function cuts off the number at the specified decimal places without performing any rounding, achieving the same result as ROUNDDOWN.
Easily Manage Salary Data and Formulas with WPS Office
WPS Spreadsheet fully supports Excel functions like ROUNDDOWN and TRUNC, making it easy to convert INR amounts to lakhs, format currency, and manage large HR or financial datasets efficiently.
- 1. Open your dataset in WPS: Launch WPS Spreadsheet and open your existing .xlsx file containing the salary amounts.
- 2. Enter the conversion formula: In a new column, type =ROUNDDOWN(A2/100000, 2) to divide the value by 100,000.
- 3. Fill the data: Drag the fill handle downward to instantly convert the rest of your column's data into lakhs.
Frequently Asked Questions
What is a lakh in the Indian numbering system?
A lakh is a unit in the Indian numbering system equal to one hundred thousand (100,000). For example, 1,000,000 is represented as 10 lakhs. Dividing your raw salary by 100,000 is the standard way to find its value in lakhs.
Why should I use ROUNDDOWN instead of the standard ROUND function?
ROUNDDOWN strictly removes extra decimal values without rounding the number up. If you use ROUND, a number like 1,760,260 divided by 100,000 would round up to 17.61 instead of the desired 17.60, artificially inflating the reported figure.
Can I automatically add the word 'Lakhs' next to the converted number?
Yes. You can combine the formula with the ampersand operator to append text. Use the formula =ROUNDDOWN(A2/100000,2) & " Lakhs". Note that doing this turns the cell value into text, which means you cannot use it in further mathematical calculations.
