UPLUS in Google Sheets: Preserve a Number Without Changing Its Sign
Understand UPLUS in Google Sheets as a numeric identity operation, with signed-input examples, explicit branching and limits on unverified text conversion.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =UPLUS(-12) has expected result -12. UPLUS returns the specified number unchanged. Despite the word “plus,” it does not make a negative number positive.
Syntax and parameter
=UPLUS(value)
The single value argument is required. No optional parameters or defaults are documented. Google’s UPLUS reference describes an unchanged numeric result.
For an already numeric cell B2, =UPLUS(B2) therefore preserves its value. In an ordinary worksheet, the direct reference =B2 is usually simpler. UPLUS can still be useful when an explicit named operation makes a generated formula or a choice between operations easier to read.
The documented contract is about the numeric value. It does not promise to copy the source cell’s formatting, note, validation rule or other cell properties.
Worked example: preserve signed adjustments
Enter this table in A1:B5:
| Row | A: Adjustment | B: Amount |
|---|---|---|
| 1 | Adjustment | Amount |
| 2 | Increase | 12 |
| 3 | Decrease | -12 |
| 4 | None | 0 |
| 5 | Fractional increase | 2.5 |
In C1 enter Unchanged amount. Fill the following from C2 to C5:
=UPLUS(B2)
Expected results are 12, -12, 0, 2.5. The negative adjustment stays negative and the fractional value stays fractional. UPLUS does not round, remove a sign or add a fixed amount.
The source total and the total of the preserved results both equal 2.5:
=SUM(B2:B5)
=SUM(C2:C5)
This gives a simple arithmetic check for the small table. A matching total alone would not establish row-by-row identity in an arbitrary dataset, because errors in different rows could cancel out.
UPLUS, UMINUS and ABS serve different purposes
For the input -12:
| Formula | Expected result | Intended operation |
|---|---|---|
=UPLUS(-12) |
-12 | Keep the number |
=UMINUS(-12) |
12 | Reverse the sign |
=ABS(-12) |
12 | Take the magnitude |
For positive 12, UPLUS and ABS both give 12, but UMINUS gives -12. Google’s UMINUS reference documents multiplication by -1. ABS and UMINUS should not be treated as interchangeable merely because both return 12 for a negative input.
If the requirement is “show a nonnegative magnitude,” UPLUS is not the operation to choose. If the requirement is “reverse the existing direction,” preserving the value is also insufficient.
Advanced application: explicitly keep or reverse an amount
Use the original amounts in B2:B5. Enter numeric reversal flags 0, 1, 1, 0 in D2:D5, where 1 means reverse the sign and 0 means keep the signed amount. In E2, enter and fill down:
=IF(D2=1,UMINUS(B2),UPLUS(B2))
Expected results are 12, 12, 0, 2.5. Row 3 reverses -12 to 12. Reversing zero leaves zero. The flag represents a chosen operation, not whether the original number happens to be negative.
For this numeric example, =IF(D2=1,-B2,B2) expresses the same arithmetic more compactly. The named-function version makes the paired operations explicit. Choose the form that is clearest for the people maintaining the sheet.
The formula treats every flag other than numeric 1 as the keep branch. Validate that input column if only 0 and 1 are permitted; the expression does not itself reject an accidental 2 or a missing flag.
Errors and troubleshooting
UPLUS is not a documented general-purpose text cleaner. The short Google reference does not establish a full contract for converting numeric-looking text, blank cells, Booleans or ranges. Do not use it as a guaranteed replacement for deliberate input normalization.
If the displayed result seems different, inspect decimal places and number formatting before assuming the stored number changed. If a source calculation has an error, investigate it rather than expecting an identity operation to repair it. Check the single required argument and locale separators if the formula is rejected.
No comprehensive native error-token or array behavior matrix was established from the reviewed page. The examples above use numeric scalar inputs only.
Availability and verification
UPLUS is documented in the rolling Google Sheets service. Its original introduction date, first release and last functioning numbered version were not established. The named function should not be assumed to exist with the same coercions in another spreadsheet product.
NOT_TESTED_IN_GOOGLE_SHEETS. Google’s individual UPLUS and UMINUS references were inspected on October 17, 2026. Signed arithmetic and branch outputs were independently calculated; no native Sheets session or screenshot is claimed.