Does Microsoft Forms Support Negative Quiz Scoring?
Question details
The user wants to know if it is possible to assign negative points to incorrect answers in Microsoft Forms quizzes to enforce penalty scoring.

- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Creating a quiz and attempting to set a negative value in the Points field to penalize incorrect choices.
- Observed behavior
- Microsoft Forms only accepts positive numbers for correct answers; the Points field rejects negative values, preventing direct penalty scoring.
Keep in mind that Microsoft Forms natively restricts the 'Points' field to positive numbers only, so direct penalty scoring requires exporting the results for manual calculation.
Submit Feature Feedback to Microsoft
Currently, Microsoft Forms does not support negative points natively. Submitting a feature request is the best way to notify the development team about this need.
Microsoft Forms is designed for basic quizzing and currently only supports rewarding positive points for correct answers. Any attempt to type a minus sign will be rejected by the system.
To encourage the implementation of penalty scoring, users are encouraged to utilize the built-in feedback tool.
Log into your Microsoft 365 account and open the Microsoft Forms dashboard.
Click on the '?' (Help and Feedback) icon located in the top right corner of the screen.
Select 'Feedback' from the dropdown menu, choose 'I have a suggestion', and detail your request for negative quiz scoring before clicking submit.

Manually Calculate Penalty Scores via Spreadsheet Export
Since Forms cannot automatically deduct points, you can export the quiz results to a spreadsheet application and use custom formulas to calculate negative scores.
Need to analyze quiz results? Try WPS Office
While Microsoft Forms restricts negative scoring, you can easily export your quiz data and calculate custom penalty scores using WPS Spreadsheet. WPS Office is a free, lightweight suite offering high compatibility with Microsoft Office formats.
- 1. Download WPS Office: Install WPS Office for free on your PC or mobile device.
- 2. Open Exported Data: Open the .xlsx file you downloaded from Microsoft Forms directly in WPS Spreadsheet.
- 3. Calculate Scores: Use the formula bar to input custom IF and SUM functions to apply negative points to incorrect answers.

Frequently Asked Questions
Why does Microsoft Forms reject my negative point value?
Microsoft Forms is programmed to strictly accept positive numerical values in the Points field. Entering a minus sign will trigger a system validation error stating that only positive values are allowed.
Can I use branching logic to deduct points?
No, branching logic in Microsoft Forms only redirects respondents to different questions based on their previous answers; it does not alter the underlying scoring system or allow for point deductions.
Are there any plans for Microsoft to add negative scoring to Forms?
Microsoft frequently updates its product suite based on user feedback, but there is currently no official roadmap or timeline for adding penalty scoring. Submitting a direct feature request helps prioritize this update.
How can I calculate negative scores manually?
You can calculate negative scores manually by clicking 'Open in Excel' from the Responses tab. Once the data is in a spreadsheet, you can add a new column and use custom formulas (like the IF function) to deduct points for wrong answers.




