Cap a percentage at 100%
=MIN(B2/C2,1)Excel · result on the sample sheet: 5 rows (D2:D6)
Describe what you need and get a working MIN formula for Excel and Google Sheets, tested on real data before you copy it. MIN returns the smallest number from a list of values or ranges.
Each formula below was calculated on its own sample sheet. Open one to see the sheet, why it works, and to try it yourself.
=MIN(B2/C2,1)Excel · result on the sample sheet: 5 rows (D2:D6)
=MAX(0,(C2-B2)*24-$G$1)Excel · result on the sample sheet: 5 rows (D2:D6)
=IF(C2>B2,MIN($G$2,(C2-B2)*$G$1),0)Excel · result on the sample sheet: 5 rows (D2:D6)
=MIN(B2,$G$1)*C2+MAX(0,B2-$G$1)*C2*$G$2Excel · result on the sample sheet: 5 rows (D2:D6)
=IF(MIN(B2:E2)>=$I$1,"Passed all","Retake")Excel · result on the sample sheet: 6 rows (F2:F7)
=(B2-MIN($B$2:$B$7))/(MAX($B$2:$B$7)-MIN($B$2:$B$7))Excel · result on the sample sheet: 6 rows (C2:C7)
=MIN(B2:B9)Excel · result on the sample sheet: 3/8/2026
=MIN(1,MAX(0,($G$1-B2)/(C2-B2)))Excel · result on the sample sheet: 5 rows (D2:D6)
You describe the task in plain English, and it writes the formula, using MIN where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.
MIN returns the smallest number from a list of values or ranges.
Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the MIN function page has a practice exercise.