# 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 of**MS Excel**from the following link:https://www.microsoft.com/en-in/microsoft-365/excel

Formulas to limit percentage between 0 and100

## Jump To:

**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**The**MAX 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!!**

### Related Articles:

**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!!**

#### Rate our Tutorial0 / 5 Total Ratings 0

Your page rank: