Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
N
N converts its argument to a numeric equivalent: numbers pass through unchanged, TRUE becomes 1, FALSE becomes 0, dates become their serial number, and text strings return 0. It is occasionally used to embed a comment inside a formula (by adding N("comment") which evaluates to 0) or to coerce Boolean results to numbers for arithmetic.
Excel
=N(A2)Google Sheets
=N(A2)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Pass any value or cell reference to N (e.g., =N(A2)).
- 2Numbers and dates pass through as numbers; TRUE becomes 1; FALSE and text become 0.
- 3Use =formula + N("This adds a comment") to embed a non-printing annotation inside a complex formula.
Need a version for your data?
Try: “Convert Boolean TRUE/FALSE results to 1 and 0 so I can sum them arithmetically”