N
Definition: N is a function that returns a value converted to a number.
Syntax: =N(value)
Situation: This formula is appropriate when you need to convert a value to a number.
Example: If you have a text string “123”, the formula =N(“123”) can be used, which returns the number 123.