Does TO_PERCENT multiply my number by 100 automatically?

Yes. TO_PERCENT takes a decimal (0.25) and directly formats it as a percentage (25%). If you pass it an integer like 5, it displays as 500%, not 5%. Always ensure your input is already in decimal form (0.05 for 5%).

Can I combine TO_PERCENT with other functions like AVERAGE or VLOOKUP?

Absolutely. TO_PERCENT accepts any formula that returns a number: =TO_PERCENT(AVERAGE(...)), =TO_PERCENT(VLOOKUP(...)), =TO_PERCENT(IF(...)). Nest it around any numeric formula to display the result as a percentage.

How do I control decimal places in the percentage output?

TO_PERCENT formats to two decimal places by default. For custom precision, use ROUND() or TEXT(): =TEXT(TO_PERCENT(0.456), "0%") for no decimals, or apply custom number formatting to the cell after the formula calculates.

What's the difference between TO_PERCENT and just formatting a cell as a percentage?

Formatting a cell as percentage multiplies the underlying value by 100; TO_PERCENT is a function that does both formatting and conversion together, always returning text with the % symbol. Use TO_PERCENT for display, formatting for calculations.

TO_PERCENT function

Converts decimal values to percentage format, displaying numbers like 0.25 as 25% for easy readability in spreadsheets and reports.

=TO_PERCENT(value)

Generate a TO_PERCENT formula

Describe what you need. The generator will reach for TO_PERCENT where TO_PERCENT is the right tool, and tell you when it is not.

Arguments

How TO_PERCENT reads its arguments

Argument	Required	Description
value	Required	A decimal or numeric value between 0 and 1 (or any positive number); values outside this range display as valid percentages (e.g., 1.5 becomes 150%).

Returns

A percentage-formatted number as text, with the % symbol appended.

Availability

Excel: Not available · Google Sheets: Supported

Worked examples

1. Express a property's days on market as a percentage of the average

Address	Beds	Baths	List Price	Days on Market
123 Oak St	3	2	450000	15
456 Maple Ave	4	3	625000	8
789 Pine Rd	2	1	325000	42

=TO_PERCENT(8/AVERAGE($E$2:$E$4))

Result: 36.92%

The 456 Maple Ave property has been on the market for 8 days. The average days on market is (15+8+42)/3 = 21.67 days. Dividing 8 by 21.67 gives 0.3692, which TO_PERCENT formats as 36.92%, showing this property sold faster than typical.

2. Show the least expensive property's price as a percentage of the most expensive

Address	Beds	Baths	List Price	Days on Market
123 Oak St	3	2	450000	15
456 Maple Ave	4	3	625000	8
789 Pine Rd	2	1	325000	42

=TO_PERCENT(MIN($D$2:$D$4)/MAX($D$2:$D$4))

Result: 52%

The minimum price is $325,000 (789 Pine Rd) and the maximum is $625,000 (456 Maple Ave). Dividing 325000 by 625000 equals 0.52, which TO_PERCENT displays as 52%, indicating the entry-level property costs just over half the price of the premium listing.

3. Calculate how a property's price compares to the average market price

Address	Beds	Baths	List Price	Days on Market
123 Oak St	3	2	450000	15
456 Maple Ave	4	3	625000	8
789 Pine Rd	2	1	325000	42

=TO_PERCENT(D2/AVERAGE($D$2:$D$4))

Result: 96.43%

For 123 Oak St at $450,000: the average price is ($450,000+$625,000+$325,000)/3 = $466,667. Dividing 450000 by 466667 equals 0.9643, which TO_PERCENT formats as 96.43%, showing this mid-range property is priced slightly below market average.

Common errors

Which TO_PERCENT error are you seeing?

Error	Why it happens	How to fix it
#VALUE!	The value argument contains text or non-numeric content, e.g., =TO_PERCENT("N/A") when a cell contains text instead of a number.	Verify all inputs are numeric. Use TO_PURE_NUMBER() or VALUE() to convert text representing numbers. For cells with errors or missing data, use IFERROR() to provide a numeric fallback.
#REF!	The formula references a cell or range that no longer exists, e.g., =TO_PERCENT(OFFSET(A1,5,5)) pointing to an invalid location or a deleted row/column.	Verify all cell references are valid and no rows or columns containing referenced data have been deleted. Use absolute references ($A$1) if the formula will be copied to prevent range shifts.
#DIV/0!	The value argument is the result of division by zero, e.g., =TO_PERCENT(AVERAGE(E2:E4)/0) when attempting to calculate a ratio with zero as the denominator.	Check for zero values in denominators. Use IFERROR(numerator/denominator, 0%) or IF(denominator=0, "N/A", numerator/denominator) to handle edge cases safely.

Tips and when to use something else

TO_PERCENT automatically appends the % symbol and handles decimal-to-percentage conversion in one step—no need to multiply by 100 manually.
Use TO_TEXT() if you need percentage output as text for string operations, or TO_PURE_NUMBER() to convert a formatted percentage back to its decimal equivalent for further calculations.
Combine TO_PERCENT with nested functions like AVERAGE, IF, or MIN/MAX to calculate ratios inline; the function always formats the final result as a percentage with two decimal places.
TO_PERCENT works with values greater than 1 or negative numbers—e.g., TO_PERCENT(1.5) returns 150% and TO_PERCENT(-0.25) returns -25%—useful for markups and variance analysis.

Related functions

TO_TEXTConverts a value to text format, returning its content as plain text regardless of the original data type or formatting.TO_PURE_NUMBERConverts a value to its pure numeric form, removing formatting like currency, percentage, or text labels to expose the underlying number.TO_DOLLARSConverts a numeric value to a text string formatted as currency with a dollar sign, commas, and two decimal places for display.IFThe IF function returns one value if a condition is true and another (or nothing) if it is false, letting you branch logic in a cell.BYROWBYROW applies a LAMBDA to each row of a range and returns a vertical array of the results, enabling row-wise calculations in Excel 365 and Google Sheets.

Frequently asked questions

Does TO_PERCENT multiply my number by 100 automatically?: Yes. TO_PERCENT takes a decimal (0.25) and directly formats it as a percentage (25%). If you pass it an integer like 5, it displays as 500%, not 5%. Always ensure your input is already in decimal form (0.05 for 5%).
Can I combine TO_PERCENT with other functions like AVERAGE or VLOOKUP?: Absolutely. TO_PERCENT accepts any formula that returns a number: =TO_PERCENT(AVERAGE(...)), =TO_PERCENT(VLOOKUP(...)), =TO_PERCENT(IF(...)). Nest it around any numeric formula to display the result as a percentage.
How do I control decimal places in the percentage output?: TO_PERCENT formats to two decimal places by default. For custom precision, use ROUND() or TEXT(): =TEXT(TO_PERCENT(0.456), "0%") for no decimals, or apply custom number formatting to the cell after the formula calculates.
What's the difference between TO_PERCENT and just formatting a cell as a percentage?: Formatting a cell as percentage multiplies the underlying value by 100; TO_PERCENT is a function that does both formatting and conversion together, always returning text with the % symbol. Use TO_PERCENT for display, formatting for calculations.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17