# How to cap a value in Excel

This page will describe how to limit a percentage between 0 and 100 in Excel. To limit a percentage value that falls between 0% and 100%, you can use a formula based on the MIN and

This page will describe how to limit a percentage between 0 and 100 in Excel. To limit a percentage value that falls between 0% and 100%, you can use a formula based on the MIN and MAX functions. Lets get into this article!! Get an official version ofMS Excelfrom the following link:https://www.microsoft.com/en-in/microsoft-365/excel

Formulas to limit percentage between 0 and100

• General Formula
• Syntax Explanations
• Example
• Wrap-Up

## General Formula:

• Use the below formula to limit the percentage between 0 and 100.

=MAX(0,MIN(A1,1))

## Syntax Explanations:

• MAX  TheMAX Function returnsthe largest numeric value from the range of input values.
• MIN  This function will return the smallest numeric value from the range of input values. Read more on the MIN Function.
• Comma symbol (,)  It is a separator that helps to separate a list of values.
• Parenthesis ()  The main purpose of this symbol is to group the elements.
• Range (A1) It represents the input value from your worksheet.

## Example:

• Now we are going to see how to limit the percentage value between 0 and 100.
• Refer to the below example image.
• Here, we will give the input values in Column B.
• Then, enter the given formula in the formula bar section.
• After applying the formula, it will limit a percentage and return the result in Cell D3.

Example

## Wrap-Up:

Here, we guided you to learn the formulas to limit the percentage between 0 and 100 in Excel. Hope that this article is useful to you. If you have any doubts/queries, feel free to share it in the below comment section. To know further updates keep in touch with our website Geek Excel and Excel Formulas!!

• Excel Formulas to Calculate the Average Pay per Week!!
• Excel Formulas to Calculate the Last N Numeric Values!!!
• Formulas for Counting the Dates from a given Year in Excel!!
• Excel Formulas to Calculate the Average of a Numbers that Ignores Zero!!