Formula Errors

How to Split a Number into Two Parts with a 15% Ratio in Excel

Algirdas JasaitisAlgirdas Jasaitis Nov 10, 2026 869 views

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.

How to Split a Number into Two Parts with a 15% Ratio in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Enter the Total Number

Type your starting whole number into a blank cell. For this example, type the total into cell A1.

2
Calculate the Smaller Part

Select cell B1, input the formula =ROUNDDOWN(A1*15%/(1+15%), 0), and press Enter. This isolates the smaller integer portion.

3
Calculate the Larger Part

Select cell C1, input the formula =A1-B1, and press Enter. This subtracts the smaller piece from the total, yielding the larger remaining portion.

Use the ROUNDDOWN and Subtraction Formulas
Ratio Accuracy: Because both calculated parts are forced to be whole numbers using ROUNDDOWN, the actual final ratio may be slightly below exactly 15%.
Try WPS Spreadsheet

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. 1. Open WPS Spreadsheet: Launch WPS Office and click 'Spreadsheet' to create a new blank workbook or open your existing file.
  2. 2. Input Your Base Value: Click on cell A1 and type the total whole number you want to divide.
  3. 3. Apply the Formula: Click on cell B1, type =ROUNDDOWN(A1*15%/(1+15%), 0) into the formula bar, and press Enter.
  4. 4. Find the Remaining Part: Click on cell C1 and type =A1-B1 to instantly display the larger remaining integer.
100% compatible with Microsoft Excel formulas, functions, and file formats.Lightweight architecture ensures smooth performance on all devices.Built-in intuitive formula suggestions to help you avoid syntax errors.Free to use for everyday data calculation and spreadsheet tasks.
microsoft office alternative - wps office

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.