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
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 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.
Sample data
- To cap a calculated percentage at 100%, you need to use the following formula in formula bar.
=[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)(1,B5/C5)
Use the Formula
- Then, you have to Hit the Enter key to get the result as shown below in the cell E5.
Result for cell E5
- Now, you need to press Ctrl+D key to get the results in all other columns.
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!! *And Excel Formulas *!!
Related Articles:
Top comments (0)