N

Definition of N

Returns the argument provided as a number.

Sample Usage

N(A2)

N(4)

Syntax

N(value)

• value - The argument to be converted to a number.

  • If value is TRUE, N returns 1.

  • If value is a number, the number is returned.

  • If value is a date or time, N returns a generated serial number, based on the number of days since December 30, 1899.

    1. Negative values are interpreted as days before this date, and fractional values indicate time of day past midnight.

  • If value is FALSE or any value not listed above, N returns 0.

Notes

• When using N on numeric values in other cells, formatting (into currencies, scientific notation, etc.) is lost. To specify formatting on the return value of N, simply apply the format desired to the cell containing the formula.

• This function is, in fact, rarely necessary as Google Spreadsheet automatically converts between most formats appropriately. It is provided primarily for compatibility with formulas used in other spreadsheet packages.

See Also

TO_DATE: Converts a provided number to a date.

T: Returns string arguments as text.

In order to use the N formula, start with your edited Excellentable

Then type in the N Formula in the area you would like to display the outcome:

Type in the complete N formula for a cell as shown below:

Excellentable will generate the outcome when hitting enter. 

	A	B	C
1	State	Population	Total area in mi2	Land area in mi2	Water area in mi2
2	Alabama	4833722	52,420 (135,767)
3	Alaska	735132	665,384 (1,723,337)
4	Arizona	6626624	113,990 (295,233)
5	Arkansas	2959373	53,179 (137,733)
6	California	38332521	163,695 (423,968)
7	Colorado	5268367	104,094 (269,602)
8	Connecticut	3596080	5,543 (14,356)
9	Delaware	925749	2,489 (6,446)
10	Florida	19552860	65,758 (170,312)
11	Georgia	9992167	59,425 (153,910)
12	Hawaii	1404054	10,932 (28,314)
13	Idaho	1612136	83,569 (216,443)

	D	E	F
1

House seat(s)

50,645 (131,170)

1,775 (4,597)

7

570,641 (1,477,950)

94,743 (245,383)

1

113,594 (294,207)

396 (1,026)

9

52,035 (134,770)

1,143 (2,960)

4

155,779 (403,466)

7,916 (20,502)

53

103,642 (268,432)

452 (1,171)

7

4,842 (12,541)

701 (1,816)

5

1,949 (5,048)

540 (1,399)

1

53,625 (138,888)

12,133 (31,424)

27

57,513 (148,958)

1,912 (4,950)

14

6,423 (16,635)

4,509 (11,678)

2

82,643 (214,044)

926 (2,398)

2

TRUE

TRUE

TRUE

FALSE

TRUE

FALSE

TRUE

FALSE

TRUE

FALSE

TRUE

FALSE