Return a Blank Excel Cell When Stock Is Above the Reorder Level in WPS Office
Question details
The user needs an Excel formula in WPS Office Spreadsheets that returns a blank cell when physical stock is greater than the reorder trigger level and calculates the difference when a reorder is needed.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is building a stock reorder worksheet and wants order quantity suggestions only when inventory falls to or below the minimum reorder level.
- Observed behavior
- The formula should display an empty cell when stock is above the trigger level and show the difference when a reorder is needed.
Open your WPS Spreadsheets workbook and confirm that the stock value is in J5 and the reorder trigger level is in I5, or adjust the cell references in the formula to match your worksheet.
Use an IF Formula to Return a Blank When Stock Is Above the Reorder Level
Use this formula when you have a stock value in one cell and a minimum reorder trigger in another, and you want the order quantity to appear only when stock is at or below the trigger.
WPS Office Spreadsheets supports the same IF function syntax used in Excel. The formula compares the stock value with the trigger level and returns an empty text string when no reorder is required.
Click the cell where the reorder result should appear, for example K5.
Type =IF(J5>I5,"",J5-I5) into the formula bar and press Enter.
If your stock and trigger values are not in J5 and I5, replace J5 and I5 with the correct cell references in your worksheet.
Create a Blank Reorder Result with the WPS Spreadsheets IF Formula
Use WPS Office Spreadsheets to manage stock reorder logic with a simple IF formula. It returns a blank cell when stock is above the reorder trigger and calculates the reorder quantity only when needed.
- 1. Open your stock workbook: Launch WPS Office and open the Excel workbook that contains the stock and reorder level data.
- 2. Select the result cell: Click the cell where you want the blank or reorder quantity result to appear, such as K5.
- 3. Enter the IF formula: Type =IF(J5>I5,"",J5-I5) in the formula bar and press Enter.
- 4. Verify the result: Change the stock value to test both outcomes: a stock above the trigger returns a blank cell, and a stock at or below the trigger shows the reorder quantity.
Frequently Asked Questions
Why does my IF formula return 0 instead of a blank cell?
This can happen if the formula uses 0 rather than "" as the value-if-true argument. In WPS Spreadsheets, use =IF(J5>I5,"",J5-I5) with empty double quotes so the cell stays blank.
How can I make the formula blank when stock is equal to the reorder level?
Adjust the comparison operator. To blank when stock is equal to or above the trigger, use =IF(J5>=I5,"",I5-J5) so the result appears as a positive reorder quantity when stock is below the trigger.
Can I apply this reorder formula to an entire column?
Yes. Enter the formula in the first result cell, then use the fill handle to copy it down. WPS Spreadsheets automatically adjusts relative cell references like J5 and I5 for each row.
What should I do if my stock and trigger cells are not in J5 and I5?
Replace J5 and I5 in the formula with your actual stock cell and reorder trigger cell references, for example =IF(B2>C2,"",B2-C2).
