INT Formula

What Does It Do ?
This function rounds a number down to the nearest whole number. Number Integer 1.5 1  =INT(C4) 2.3 2  =INT(C5) 10.75 10  =INT(C6) -1.47589 -2  =INT(C7)
Syntax
=INT(Number)
Formatting
No special formatting is needed.
Example
The following table was used by a school to calculate the age a child when the
school year started.
A child can only be admitted to school if they are over 8 years old.
The Birth Date and the Term Start date are entered and the age calculated.
Table 1 shows the age of the child with decimal places
	Table 1
	Birth Date	Term Start	Age
	1-Jan-80	1-Sep-88	8.668035592	=(D27-C27)/365.25
	5-Feb-81	1-Sep-88	7.570157426
	20-Oct-79	1-Sep-88	8.8678987
	1-Mar-81	1-Sep-88	7.504449008
Table 2 shows the age of the child with the Age formatted with no decimal places.
This has the effect of increasing the child age.
	Table 2
	Birth Date	Term Start	Age
	1-Jan-80	1-Sep-88	9	=(D38-C38)/365.25
	5-Feb-81	1-Sep-88	8
	20-Oct-79	1-Sep-88	9
	1-Mar-81	1-Sep-88	8
Table 3 shows the age of the child with the Age calculated using the =INT() function to
remove the decimal part of the number to give the correct age.
	Table 3
	Birth Date	Term Start	Age
	1-Jan-80	1-Sep-88	8	=INT((D49-C49)/365.25)
	5-Feb-81	1-Sep-88	7
	20-Oct-79	1-Sep-88	8
	1-Mar-81	1-Sep-88	7
Note
The age is calculated by subtracting the Birth Date from the Term Start to find the
age of the child in days.
The number of days is then divided by 365.25
The reason for using 365.25 is to take account of the leap years.

Instant Formula

You can create a chart quickly without having to use the chart button on
the toolbar by pressing the function key F11 whilst inside a range of data.
	Jan	Feb	Mar
North	45	50	50
South	30	25	35
East	35	10	50
West	20	50	5
Click anywhere inside the table above.
Then press F11.

Info Formula

	System Information
Current directory	C:\Users\Madushana\Documents\	=INFO("directory")
Available bytes of memory	1,048,576	=INFO("memavail")
Memory in use	2,736,804	=INFO("memused")
Total bytes of memory	3,785,380	=INFO("totmem")
Number of active worksheets	156	=INFO("numfile")
Cell currently in the top left of the window	$A:$A$1	=INFO("origin")
Operating system	Windows (32-bit) NT 6.02	=INFO("osversion")
Recalculation mode	Automatic	=INFO("recalc")
Excel version	11.0	=INFO("release")
Name of system. (PC or Mac)	pcdos	=INFO("system")
What Does It Do?
This function provides information about the operating environment of the computer.
Syntax
=INFO(text)
text : This is the name of the item you require information about.
Formatting
The results will be shown as text or a number depending upon what was requested.

Indirect Formula

				Jan	Feb	Mar
			North	10	20	30
			South	40	50	60
			East	70	80	90
			West	100	110	120
					Type address of any of the cells in the above table, such as G6 :	G6
					The value in the cell you typed is :	80
						=INDIRECT(H9)
What Does It Do ?
This function converts a plain piece of text which looks like a cell address into a usable
cell reference.
The address can be either on the same worksheet or on a different worksheet.
Syntax
=INDIRECT(Text)
Formatting
No special formatting is needed.
Example 1
This example shows how data can be picked form other worksheets by using
the worksheet name and a cell address.
The example uses three other worksheets named NORTH, SOUTH and EAST.
The data on these three sheets is laid out in the same cells on each sheet.
When a reference to a sheet is made the exclamation symbol ! needs to be placed
between the sheet name and cell address acting as punctuation.
				Type the name of the sheet, such as North :	North
				Type the cell to pick data from, such as C8 :	C8
				The contents of the cell C8 on North is :	#REF!
					=INDIRECT(G33&"!"&G34)
The =INDIRECT() created a reference to =NORTH!C8