How to Display No Bonus When an Excel Score Is Below 63 in WPS Office
Question details
The user needs a WPS Office Excel formula for a Yahtzee scorecard that returns 35 points when the upper-section total reaches 63 and displays the text No Bonus when the total is below 63.
- Product
- WPS Office Excel
- Device & OS
- not provided
- Scenario
- Creating a Yahtzee scorecard in WPS Office Excel where the upper-section total in B6:B11 determines whether a 35-point bonus is awarded.
- Observed behavior
- The desired cell should show 35 when the condition is met and No Bonus when it is not.
Open the Yahtzee scorecard in WPS Office Excel and verify the upper-section scores are stored in the range B6:B11 before applying the formula.
Use an IF Formula to Return 35 or "No Bonus" Based on the Upper-Section Total
Use this solution when the bonus cell must automatically evaluate the upper-section total and display either 35 points or No Bonus.
The IF function checks whether the SUM of the upper-section range meets the 63-point threshold. If TRUE, WPS Office Excel returns 35; if FALSE, it returns the text "No Bonus".
Click the cell where the bonus result should appear, such as the empty bonus cell next to the upper-section total in the WPS Excel scorecard.
Type =IF(SUM(B6:B11)>=63,35,"No Bonus") and adjust B6:B11 to match the range that contains your upper-section scores.
Press Enter. WPS Office Excel displays 35 when the total reaches 63 or above and No Bonus when the total is below 63.
Use WPS Office Excel to Return "No Bonus" When a Score Is Below 63
Open your scorecard in WPS Office Excel and create an IF formula that checks the SUM of B6:B11. WPS Spreadsheets handles Excel formulas and formatting, so the bonus cell updates automatically.
- 1. Open the workbook in WPS Office Excel: Launch WPS Office, open the Yahtzee scorecard workbook, and switch to the worksheet that contains the upper-section scores in B6:B11.
- 2. Select the bonus result cell: Click the cell where the bonus or No Bonus result should appear.
- 3. Enter the IF formula: Type =IF(SUM(B6:B11)>=63,35,"No Bonus") and adjust the range if your scores are in different cells.
- 4. Confirm and verify: Press Enter and test by changing a score to see 35 appear at 63 or above and No Bonus below 63.
Frequently Asked Questions
Why does my formula return 0 instead of No Bonus?
The IF formula likely has 0 as the value_if_false argument. Replace it with the text "No Bonus", for example =IF(SUM(B6:B11)>=63,35,"No Bonus").
Can I change the range B6:B11 to match my scorecard?
Yes. Select a different range inside SUM that contains your upper-section scores. WPS Office Excel automatically recalculates the result when those cells change.
What happens when the upper-section total equals 63?
The formula uses >=, so a total of exactly 63 returns 35 points. It only returns No Bonus when the total is below 63.
Will this formula work if the file is opened in Microsoft Excel?
Yes. The IF and SUM functions use standard Excel syntax, so the formula works in both WPS Office Excel and Microsoft Excel.
