TRUNC

Description

Truncates a number to a certain number of significant digits by dropping less significant digits.

Sample Usage

TRUNC(3.141592654,2)

TRUNC(A1,0)

TRUNC(1.23)

Syntax

TRUNC(value, [places])

• value - The value to be truncated.

• places - [ OPTIONAL - 0 by default ] - The number of significant digits retained to the right of the decimal point.

  • If places is greater than the number of significant digits in value, the value is unchanged.

  • If places is negative, all digits to the right of the decimal place are discarded, and the specified number of digits to the left of the decimal place are changed to zero. If the result of TRUNC is zero, TRUNC will display 0.

Notes

• The result of TRUNC is not rounded up or down.

To use the TRUNC Formula, simply begin with your edited Excellentable:

Then begin typing the TRUNC formula in the area you would like to display the outcome: 

By adding the values you would like to calculate, Excellentable generates the outcome:

	A	B	C	D
1	State	Population	Total area in mi2	Land area in mi2	Water area in mi2	House seat(s)
2	Alabama	4833722	52,420 (135,767)	50,645 (131,170)
3	Alaska	735132	665,384 (1,723,337)	570,641 (1,477,950)
4	Arizona	6626624	113,990 (295,233)	113,594 (294,207)
5	Arkansas	2959373	53,179 (137,733)	52,035 (134,770)
6	California	38332521	163,695 (423,968)	155,779 (403,466)
7	Colorado	5268367	104,094 (269,602)	103,642 (268,432)
8	Connecticut	3596080	5,543 (14,356)	4,842 (12,541)
9	Delaware	925749	2,489 (6,446)	1,949 (5,048)
10	Florida	19552860	65,758 (170,312)	53,625 (138,888)
11	Georgia	9992167	59,425 (153,910)	57,513 (148,958)
12	Hawaii	1404054	10,932 (28,314)	6,423 (16,635)
13	Idaho	1612136	83,569 (216,443)	82,643 (214,044)
14
15

	E	F
1

1,775 (4,597)

7.556

94,743 (245,383)

1

396 (1,026)

9

1,143 (2,960)

0.5

7,916 (20,502)

53

452 (1,171)

7

701 (1,816)

5

540 (1,399)

1

12,133 (31,424)

27

1,912 (4,950)

14

4,509 (11,678)

2

926 (2,398)

2