How to Split a Number into Two Parts with a 15% Ratio in Excel
Question details
The user needs to divide a whole number into two integer parts so that the smaller part is approximately 15% of the larger part.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Allocating a total value into two distinct integer portions based on a specific percentage ratio without resulting in decimals.
- Observed behavior
- Calculating the exact mathematical ratio results in decimal fractions, requiring the use of a rounding function to ensure both resulting numbers are whole integers that sum correctly to the original total.
Ensure that the total whole number you wish to divide is entered into a single cell in your spreadsheet, such as A1, and that your calculation settings are set to automatic.
Use the ROUNDDOWN and Subtraction Formulas
Extract the smaller portion first using the ROUNDDOWN function to maintain whole numbers, then subtract it from the total to get the larger portion.
To find a part that is exactly 15% of another part, you must calculate the smaller amount out of the total combined parts (100% + 15% = 115%). We use ROUNDDOWN to ensure the result is a whole number that does not exceed the target ratio.
Type your starting whole number into a blank cell. For this example, type the total into cell A1.
Select cell B1, input the formula =ROUNDDOWN(A1*15%/(1+15%), 0), and press Enter. This isolates the smaller integer portion.
Select cell C1, input the formula =A1-B1, and press Enter. This subtracts the smaller piece from the total, yielding the larger remaining portion.

Easily Calculate and Split Numbers in WPS Spreadsheet
WPS Spreadsheet fully supports standard Excel mathematical functions, making it incredibly simple to divide numbers by ratios and process large datasets seamlessly.
- 1. Open WPS Spreadsheet: Launch WPS Office and click 'Spreadsheet' to create a new blank workbook or open your existing file.
- 2. Input Your Base Value: Click on cell A1 and type the total whole number you want to divide.
- 3. Apply the Formula: Click on cell B1, type =ROUNDDOWN(A1*15%/(1+15%), 0) into the formula bar, and press Enter.
- 4. Find the Remaining Part: Click on cell C1 and type =A1-B1 to instantly display the larger remaining integer.

Frequently Asked Questions
Why do we divide by (1+15%) in the formula?
If the smaller part is 15% of the larger part, then the total number represents 115% (or 1 + 15%) of the larger part. Dividing the total by 1.15 is the mathematical step required to isolate the correct base amount for the ratio.
Can I change the ratio to something other than 15%?
Yes. Simply replace '15%' in both places within the formula =ROUNDDOWN(A1*15%/(1+15%), 0) with your desired percentage, such as '20%'.
What happens if I use ROUND instead of ROUNDDOWN?
Using the standard ROUND function will round the calculation to the nearest integer. While this might be mathematically closer to the exact ratio, it could cause the smaller part to slightly exceed the strict 15% threshold of the larger part.




