Returns the argument provided as a number. Learn more
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.