UPLUS function

UPLUS coerces its argument to a number, converting text-formatted numbers and other numeric values to true numeric format.

=UPLUS(value)

Generate a UPLUS formula

Describe what you need. The generator will reach for UPLUS where UPLUS is the right tool, and tell you when it is not.

How to get a better answer
  • Name your columns by letter and by header: "column F (Net Value)" beats "the amount column".
  • State every condition, including the negatives — "not cancelled" changes the formula's shape.
  • Say where the data starts if it is not row 1, and whether it will grow.
  • Check the settings above match your spreadsheet: the wrong argument separator is a syntax error on your machine.

Arguments

How UPLUS reads its arguments
valuerequiredUPLUS →
ArgumentRequiredDescription
valueRequiredThe value to convert to a number; can be a number, text representation of a number, boolean, or cell reference. Non-numeric text returns #VALUE! error.

Returns

A number. If the value cannot be converted to a number, returns #VALUE! error.

Availability

Excel: Not available · Google Sheets: Supported

Worked examples

1. Sum text-stored quantities from a stock take

IngredientQty
Tomatoes25
Olive Oil5
Basil30
=UPLUS(D2)+UPLUS(D3)+UPLUS(D4)

Result: 60

Each quantity is stored as text (from a CSV import or manual entry). UPLUS converts each text string to a true number. Without UPLUS, concatenation would produce '25530' instead of 60.

2. Extract leading digits from text and convert to number

IngredientQty (mixed)
Tomatoes25kg
=UPLUS(LEFT(D2,2))

Result: 25

The quantity is stored with the unit attached as '25kg'. LEFT extracts '25' as text; UPLUS converts it to the number 25 so it can be used in arithmetic or comparison formulas.

3. Convert a boolean comparison into a numeric multiplier

IngredientQty
Tomatoes25
=UPLUS(D2>20)*100

Result: 100

The comparison D2>20 evaluates to TRUE. UPLUS converts TRUE to 1; multiplying by 100 yields 100. This is a concise way to apply conditional arithmetic to stock levels.

Common errors

Which UPLUS error are you seeing?
UPLUS returned an error#VALUE!
Ensure the input references a cell containing a number or text that looks like a number (e.g., '25'). If mixing text and numbers, extract the numeric portion first using LEFT, MID, or REGEX.
#N/A
Use IFERROR or IFNA to catch the error before UPLUS, e.g., =UPLUS(IFNA(D2, 0)) to default to 0 if D2 is #N/A.
#REF!
Verify that all cell references point to existing cells. Update or correct the reference to a valid cell in the spreadsheet.
ErrorWhy it happensHow to fix it
#VALUE!UPLUS receives text that is not a valid number representation, such as an ingredient name ('Tomatoes') or supplier ('Green Valley').Ensure the input references a cell containing a number or text that looks like a number (e.g., '25'). If mixing text and numbers, extract the numeric portion first using LEFT, MID, or REGEX.
#N/AThe value argument is an #N/A error from a failed lookup or a cell containing an error result.Use IFERROR or IFNA to catch the error before UPLUS, e.g., =UPLUS(IFNA(D2, 0)) to default to 0 if D2 is #N/A.
#REF!The value argument is a cell reference that has been deleted, moved, or is otherwise invalid (a broken reference from a renamed sheet or deleted column).Verify that all cell references point to existing cells. Update or correct the reference to a valid cell in the spreadsheet.

Tips and when to use something else

  • UPLUS is essential when working with CSV imports or user-entered data where numbers are stored as text—a common issue in stock-take or inventory data.
  • For converting numbers to text, use TEXT(); for more flexible text-to-number conversion with locales, reach for VALUE().
  • UPLUS mimics the unary + operator used in many programming languages, coercing its operand to numeric type without changing the value.
  • For dates or times stored as text, UPLUS won't help—use DATEVALUE() or TIMEVALUE() instead to ensure correct parsing.

Related functions

VALUEVALUE converts a text string that looks like a number, currency, or date into the underlying numeric value Excel or Sheets can use in calculations.UMINUSReturns the negative of a number, converting positive values to negative and vice versa; use it for accounting entries or reversing numeric signs.PLUSPLUS returns the sum of two numbers, making it ideal for combining values in retail calculations and data analysis.INTINT rounds any number down to the nearest whole integer, always discarding decimal places and rounding toward negative infinity.IFNAIFNA returns the result of a formula unless it evaluates to #N/A, in which case it returns a specified alternate value.

Frequently asked questions

Why does my sum of quantities give the wrong result?
If quantities are stored as text (common in CSV imports or manual entry), they concatenate instead of add: '25' + '5' + '30' becomes '25530'. Wrap each cell in UPLUS: =UPLUS(D2)+UPLUS(D3)+UPLUS(D4), or use =SUMPRODUCT(UPLUS(D2:D4)) to sum an entire range.
Can UPLUS convert dates stored as text?
UPLUS works on numeric date serials (e.g., a cell containing 45000 for a date), but not human-readable text like '2026-09-20'. Use DATEVALUE() for text dates: =DATEVALUE('2026-09-20').
Is UPLUS available in Microsoft Excel?
No, UPLUS is a Google Sheets function. In Excel, use VALUE() to convert text to numbers, or simply prepend a plus sign in a formula: =+D2.
What's the difference between UPLUS and VALUE?
Both convert text to numbers with nearly identical results. VALUE is a named function (more readable); UPLUS is the unary operator (more concise). Use VALUE for clarity or when sharing files with Excel users who need compatibility.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17