Function Problems

Calculate and Display a Percentage Range in One Excel Cell

Tauseeq MagsiTauseeq Magsi Nov 18, 2026 868 views

Question details

Calculate two percentages of a value and display the rounded results as a range in one cell.

Calculate and Display a Percentage Range in One Excel 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.”
Before you start

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.

Solution 1Recommended

Combine rounded percentage calculations with TEXT

Use this formula to display two whole-number results together in one Excel cell.

1
Select the output cell

Click an empty cell where you want the range to appear.

2
Enter the formula

In the formula bar, enter =TEXT(ROUND(C3*70%,0),"0")&" to "&TEXT(ROUND(C3*80%,0),"0") and press Enter.

3
Adjust the inputs

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.

Combine rounded percentage calculations with TEXT
The result is text: The formula displays calculated amounts, not percentage labels. Because the combined range is text, use separate numeric formulas if you need to perform further calculations on its endpoints.
WPS Spreadsheet

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. 1. Open your spreadsheet: Open WPS Spreadsheet and select File > Open to load your workbook, or create a new spreadsheet.
  2. 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. 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. 4. Customize and save: Change the cell reference or percentages as needed, then select File > Save or Save As to save the workbook.
Display two rounded percentage-based amounts in one cellOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and a familiar interfaceWork with a free, easy-to-use office suite
microsoft office alternative - wps office

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.