Formulas > =N()

How To Use N() Function in Google Sheets


Returns the argument provided as a number.

Common questions about the N formula include:
- What does the N formula do?
- How does the N formula work?
- What are the arguments required for the N formula?

The N formula can be used appropriately to convert text values to numbers, with the N function converting the text argument to a number.

The N formula can be commonly mistyped as the C formula, which is a separate function with a different purpose.

Some common ways in which the N formula can be used inappropriately include using it with text that is already numerical, as well as arguments that are non-numeric.

Common pitfalls when using the N formula include forgetting to use quotation marks with string arguments, feeling emboldened to transform non-numeric arguments to numeric values, and assuming that the N formula works with empty cells.

Common mistakes when using the N Formula include putting the numerical argument in quotation marks, putting the wrong type of argument, and using the N function instead of the NumberValue function.

Common misconceptions people might have with the N Formula include believing that the N formula works for non-numeric arguments, believing that the N formula works with empty cells, and believing that the N formula works with numerical arguments without quotation marks.

How To Actually Use N() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the N() formula:

Google Sheets Formula Tips & Techniques

18 Tips & Techniques you should master to help you work efficiently and effectively with formulas in Google Sheets

Generate a N() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.