N

Returns the argument provided as a number. Learn more

Video field
Info

N() function in Google Sheets simply returns the argument provided as a number.

This means that if the input is already a number, the function will return that number. If the input is a text string that can be interpreted as a number, such as "123" or "45.67", the function will return the corresponding numeric value.

However, if the input is not a number or cannot be interpreted as one, the function will return the value "0".

The N() function can be useful in cases where you want to ensure that a value is treated as a number in a formula or calculation, even if it is stored as text in the spreadsheet.

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!