ExcelFlux

N function

a value converted to a number.

Information

Where can you use it?

Workbook and data quality owners. Use functions that inspect cell type, errors or the calculation environment when validating a report.

Scenario in the workbook

Coerce values to numbers. Text becomes zero and TRUE becomes one.

A worked example from the workbook

RowA
6Input
742
8Pending
9TRUE
Record 1
=N(A7)

Expected result42

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=N(TRUE)
Turkish Excel · tr-TR
=S(DOĞRU)

Expected result

1

Worked examples

Coerce values to numbers. Text becomes zero and TRUE becomes one.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Input
7 42
8 Pending
9 TRUE
Case Formula Expected result
Record 1 =N(A7) 42
Record 2 =N(A8) 0
Record 3 =N(A9) 1
Microsoft Excel reference