Create an Excel IF Formula with a Minimum Value
Question details
Create a formula that returns a blank unless C49 is Y, then returns at least 750.

- 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.
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.
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.
In Excel, click the empty cell where you want the result to appear.
Type =IF(C49<>"Y","",MAX(750,225+I49*0.2)) in the cell or formula bar, then press Enter.
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.

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. Open the spreadsheet: Open WPS Spreadsheets and select Open to choose your Excel workbook.
- 2. Select a result cell: Click an empty cell other than C49 or I49.
- 3. Enter the formula: Type =IF(C49<>"Y","",MAX(750,225+I49*0.2)) in the formula bar and press Enter.
- 4. Test the calculation: Enter Y in C49 and a numeric value in I49, then check that the result is at least 750.

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.




