ProductSolutionsTemplatesResources

UPLUS

Returns a specified number, unchanged. Learn more

Video field
Operator

In Google Sheets, the function UPLUS is used to convert a value into a number. It returns the numeric value of the input, regardless of its original format. The UPLUS function is primarily used when you want to ensure that a cell containing a number, text, or other types of data is treated as a number in formulas and calculations.

Here's an example to illustrate how UPLUS works:

Suppose you have the following data in cells A1 to A3: A1: 5 A2: "10" A3: "$15"

If you enter the formula "=SUM(UPLUS(A1:A3))" in another cell, it will convert the values in A1 to A3 into numbers before summing them up. The UPLUS function will convert the text in cell A2 ("10") into the number 10 and the text in cell A3 ("$15") into the number 15. The sum of 5, 10, and 15 will then be calculated as 30.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!