How to Format Different Positive and Negative Values in Documents
Question details
The user needs to display unequal positive and negative uncertainty limits (e.g., +50 and -25) next to a base number, as the standard ± symbol implies identical limits.
- Product
- Word Processing and Presentation Software
- Device & OS
- not provided
- Scenario
- Formatting scientific, statistical, or mathematical data where upper and lower tolerance limits differ.
- Observed behavior
- The standard plus-minus (±) symbol is mathematically inaccurate for different values, requiring a custom text or equation workaround.
Identify the exact base number and the specific upper and lower tolerance values you need to display before applying the formatting.
Use the Equation Editor for Stacked Formatting
Use the built-in Equation feature to cleanly stack your specific positive and negative limits next to the base number.
This method produces the most professional, mathematically accurate look, resembling standard scientific notation.
Go to the Insert tab on the top ribbon and click on Equation to open the Equation Editor.
Select the 'Script' menu within the Equation tools, and choose the 'Subscript-Superscript' template to create two stacked boxes next to a main box.
Type your base number (e.g., 1000) in the large box, enter your positive limit (e.g., +50) in the top box, and your negative limit (e.g., -25) in the bottom box.
Use Inline Text Notation
A quick and universally readable way to type different limits without relying on complex formatting tools.
Express the Limits as a Data Range
Instead of using plus-minus notation, write out the absolute upper and lower boundaries.
Use WPS Office to Format Complex Mathematical Expressions
WPS Office provides a powerful, built-in Equation Editor that allows you to easily format complex numerical values, including stacked positive and negative tolerances.
- 1. Download WPS Office: Install WPS Office for free and open your document in WPS Writer.
- 2. Access the Equation Editor: Navigate to the Insert tab and click on the Equation button.
- 3. Apply Subscript-Superscript: Use the Script template to professionally stack your positive and negative values next to the base number.
Frequently Asked Questions
Can I use the standard ± symbol for different limits?
No, the standard plus-minus (±) symbol mathematically implies equal positive and negative limits (e.g., ±50 means +50 and -50). If the limits are different, using this symbol is mathematically incorrect and misleading.
How do I stack numbers without using the Equation editor?
While the Equation Editor is the best method, you can simulate it by formatting the positive number as superscript and the negative number as subscript. However, they will appear side-by-side rather than perfectly stacked.
Is the Equation editor available in presentation software?
Yes, standard presentation software, including Microsoft PowerPoint and WPS Presentation, includes an Insert > Equation feature that allows you to format stacked statistical limits accurately on your slides.
