WPS Spreadsheet IF Formula to Return a Cell Value or Minimum
Question details
The user needs an IF formula that returns the value in D3 when D3 is not blank, or the minimum value from D3:R3 when D3 is empty.
- Product
- WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- The formula is entered in C3 and evaluates the contents of D3 and the range D3:R3.
- Observed behavior
- The desired result is for C3 to display D3 when D3 contains a value and display the smallest value in D3:R3 when D3 is blank.
Confirm that D3 is the cell being tested and that D3:R3 is the complete range from which the minimum should be calculated. Select C3, or another output cell outside the tested range, before entering the formula.
Use IF, ISBLANK, and MIN in WPS Spreadsheet
Use this formula when D3 may be empty and the result should switch between D3 and the minimum value in D3:R3.
The ISBLANK function checks whether D3 is truly empty. If it is blank, MIN(D3:R3) returns the smallest numeric value in the range; otherwise, the formula returns the value from D3.
Open the worksheet and click cell C3, or another cell where you want the result to appear.
Type =IF(ISBLANK(D3),MIN(D3:R3),D3) in the formula bar or directly in the selected cell.
Press Enter to calculate the result. WPS Spreadsheet returns D3 when it contains a value and the minimum value in D3:R3 when D3 is empty.
Test for an empty result with a direct IF condition
Use this variation when D3 may contain a formula that displays an empty string rather than being truly blank.
Calculate Conditional Values with WPS Spreadsheet Formulas
WPS Spreadsheet lets you enter and evaluate IF, ISBLANK, and MIN functions in a familiar worksheet interface. Use the formula bar to return a cell value or calculate a range minimum based on whether the selected cell is empty.
- 1. Open a spreadsheet: Launch WPS Office and open the workbook containing the D3:R3 data range.
- 2. Choose the result cell: Click C3 or another output cell outside D3:R3.
- 3. Enter the conditional formula: Type =IF(ISBLANK(D3),MIN(D3:R3),D3) into the formula bar and press Enter.
- 4. Check both outcomes: Temporarily enter a value in D3 and clear it again to verify that the result switches between D3 and the range minimum.
Frequently Asked Questions
What formula returns D3 or the minimum of D3:R3?
Enter =IF(ISBLANK(D3),MIN(D3:R3),D3) in C3. The formula returns D3 when it is not blank and the minimum value in D3:R3 when it is empty.
Where should I enter the formula in WPS Spreadsheet?
Select C3, or another output cell outside the D3:R3 range, and enter the formula in the formula bar or directly in the cell.
Why does ISBLANK not detect a cell that looks empty?
ISBLANK detects a genuinely empty cell. If D3 contains a formula that returns an empty string, use =IF(D3="",MIN(D3:R3),D3) instead.
What happens if D3 contains text?
The first formula returns the text in D3 because D3 is not blank. If D3 is empty, MIN evaluates the numeric values in D3:R3 and returns the smallest one.
