Returns a value converted to a number.
Syntaxis
N(value)Argumenten
valuevereist
The value you want converted.
The N function converts a value to a number based on specific rules: numbers remain numbers, dates are converted to serial numbers, TRUE becomes 1, and FALSE or text becomes 0. It is rarely used in modern formulas because Excel automatically converts data types, but it is useful for ensuring compatibility with older spreadsheet programs.
=N("100")→0Text strings that cannot be interpreted as numbers return 0.
=N(TRUE)→1The logical value TRUE is converted to 1.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =N(value) and replace 'value' with the cell reference or data you wish to convert.
The N function is designed to return numbers only; if the input is not a number, date, or logical value, it defaults to 0.