Function Problems

Create an Excel IF Formula with a Minimum Value

Emma BrownEmma Brown Nov 18, 2026 868 views

Question details

Create a formula that returns a blank unless C49 is Y, then returns at least 750.

Create an Excel IF Formula with a Minimum Value
Product
Microsoft Excel
Device & OS
not provided
Scenario
Calculate 225 plus 20% of I49 when C49 contains Y, subject to a minimum result of 750.
Observed behavior
The desired formula should show a blank when C49 is not Y and otherwise return the greater of 750 or the calculated amount.
Before you start

Check that C49 contains the intended Y value and that I49 contains a numeric amount. Choose an empty cell for the formula rather than placing it in C49 or I49.

Solution 1Recommended

Use IF and MAX to apply the minimum value

Use this formula to return a blank when C49 is not Y and enforce a minimum of 750 otherwise.

1
Select the result cell

In Excel, click the empty cell where you want the result to appear.

2
Enter the formula

Type =IF(C49<>"Y","",MAX(750,225+I49*0.2)) in the cell or formula bar, then press Enter.

3
Check the result

Enter Y in C49 and a number in I49 to test the calculation. Change C49 to another value to confirm that the result appears blank.

Use IF and MAX to apply the minimum value
How the formula works: IF checks C49 first. When it equals Y, MAX returns the larger of 750 and 225 plus 20% of I49. Otherwise, the formula returns an empty text string.
Calculate in WPS Spreadsheets

Apply the same minimum-value formula in WPS Spreadsheets

Use IF and MAX in WPS Spreadsheets to return a blank unless C49 is Y and apply a minimum result of 750.

  1. 1. Open the spreadsheet: Open WPS Spreadsheets and select Open to choose your Excel workbook.
  2. 2. Select a result cell: Click an empty cell other than C49 or I49.
  3. 3. Enter the formula: Type =IF(C49<>"Y","",MAX(750,225+I49*0.2)) in the formula bar and press Enter.
  4. 4. Test the calculation: Enter Y in C49 and a numeric value in I49, then check that the result is at least 750.
Apply a minimum with familiar IF and MAX functionsOpen and edit Microsoft Excel XLSX filesWork with formulas in a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

What happens when the calculated amount is less than 750?

MAX(750,225+I49*0.2) returns 750 when the calculated amount is lower, provided C49 is Y.

What if C49 contains lowercase y?

Excel's text comparison is generally case-insensitive, so lowercase y also meets the Y condition in this formula.

Why does the formula show an error for I49?

Check cell I49 for nonnumeric text or an error value. The multiplication I49*0.2 requires a value that Excel can calculate.

Why does Excel reject the commas in the formula?

Some regional settings use semicolons as argument separators. In that case, enter =IF(C49<>"Y";"";MAX(750;225+I49*0.2)) and use the decimal separator required by your settings.