Calculate and Display a Percentage Range in One Excel Cell
Question details
Calculate two percentages of a value and display the rounded results as a range in one cell.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants to show 70% and 80% of a value as whole-number endpoints in a single cell.
- Observed behavior
- The desired cell displays both calculated values separated by the word “to.”
Enter the source value in a cell such as C3, and make sure it is stored as a number. Choose the two percentages you want to use as the range endpoints.
Combine rounded percentage calculations with TEXT
Use this formula to display two whole-number results together in one Excel cell.
Click an empty cell where you want the range to appear.
In the formula bar, enter =TEXT(ROUND(C3*70%,0),"0")&" to "&TEXT(ROUND(C3*80%,0),"0") and press Enter.
Replace C3 with your source cell and change 70% and 80% to the percentages you need. For example, if C3 is 100, the result is 70 to 80.

Create the Same Percentage Range in WPS Spreadsheet
Use ROUND, TEXT, and the concatenation operator in WPS Spreadsheet to calculate and display both range endpoints in one cell.
- 1. Open your spreadsheet: Open WPS Spreadsheet and select File > Open to load your workbook, or create a new spreadsheet.
- 2. Enter the source value: Type the value you want to calculate from into cell C3, or identify the cell that already contains it.
- 3. Add the range formula: Select an empty cell and enter =TEXT(ROUND(C3*70%,0),"0")&" to "&TEXT(ROUND(C3*80%,0),"0"), then press Enter.
- 4. Customize and save: Change the cell reference or percentages as needed, then select File > Save or Save As to save the workbook.

Frequently Asked Questions
How do I change the percentages used in the range?
Edit the formula in the formula bar and replace 70% and 80% with the percentages you want. Keep each percentage next to the source-cell reference.
Can I always round the endpoints up or down?
Replace each ROUND function with ROUNDUP or ROUNDDOWN. For example, ROUNDUP(C3*70%,0) rounds the first endpoint away from zero to a whole number.
Why can't I use the displayed range directly in another calculation?
The ampersands and TEXT functions combine the endpoints into text. Calculate the endpoints separately with formulas such as =ROUND(C3*70%,0) and =ROUND(C3*80%,0) when you need numeric values.
Does the formula display percentages or amounts?
It displays the amounts calculated from the source value. For example, if C3 is 100, 70% and 80% produce the range 70 to 80, without percent signs.




