Excel Formulas to find Cap percentage at 100 in excel!!
Tags: excelformula, excelformulas
Published: 2021-11-12 06:25:28

---
title: Excel Formulas to find Cap percentage at 100 in excel!!
published: true
date: 2021-11-06 17:26:18 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-cap-percentage-at-100-in-excel/
---

Before entering this article, you need to know some basic formulas. Here, if you want to use cap percentage, what would you do? You are in the right place, we will help you with simple formulas to  **find a cap percentage at 100** in Excel Office 365. Utilize the below-mentioned formulas!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Generic Formula

- Use this formula to find a cap percentage at 100 in Excel.

```
=[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)(1,A1/B1)

```

## Syntax Explanation

- **MIN** – **[MIN Function](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)** returns the smallest numeric value from the range of input values.
- **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.
- **Division (/)** – It is used for dividing values or numbers.

## Practical Examples

- For instance, you have to  **create a sample data**  in Excel.

![](https://geekexcel.com/wp-content/uploads/2021/11/Sample-data-5.png)
_Sample data_

- To cap a calculated percentage at 100%, you need to use the following formula in **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)(1,B5/C5)

```

![](https://geekexcel.com/wp-content/uploads/2021/11/Use-the-Formula-6.png)
_Use the Formula_

- Then, you have to  **Hit the Enter key**  to get the result as shown below in the **cell E5**.

![](https://geekexcel.com/wp-content/uploads/2021/11/Result-for-cell-E5.png)
_Result for cell E5_

- Now, you need to  **press Ctrl+D key**  to get the results in all other columns.

![](https://geekexcel.com/wp-content/uploads/2021/11/Output-1.png)
_Output_

## Bottom-Line

This article gives you complete information about the ** ** simple formulas to  **find a cap percentage at 100** in Excel Office 365. Hope that this article is useful to you. Don’t forget to share your valuable  **feedback**  in the below section. Thank you so much for Reading!! Keep learning on **[Geek Excel](https://geekexcel.com/)!! **And [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Related Articles:**

- **[How to Create a Column Chart With Percentage Change in Excel?](https://geekexcel.com/how-to-create-a-column-chart-with-percentage-change-in-excel/)**
- **[Excel Formulas to Calculate the Amount based on Percentage!!](https://geekexcel.com/excel-formulas-to-calculate-the-amount-based-on-percentage/)**
- **[Excel Formulas to Get the Percentage of Total ~ Easily!!](https://geekexcel.com/excel-formulas-to-get-percentage-of-total/)**
- **[Formulas to Get the Total From the Percentage ~ Easy Tips!!](https://geekexcel.com/excel-formulas-to-get-the-total-from-the-percentage/)**