Index,Rept,Even,Odd,Abs,Floor,Ceiling Function in Excel

 

Index Function

 

=INDEX(A1:C6,5,2)

 

	A	B	C
1	Name	Roll No	Gender
2	Raman	1256324	Male
3	Radha	1256789	Female
4	Deepak	1257254	Male
5	Deepika	1257719	Female
6	Rahul	1258184	Male
		Index
		1257719

 

Rept Function

 

=REPT("* ",B2)

 

	A	B	C
1	Software	Rating	Star
2	Ms Office	5	* * * * *
3	PhotoShop	4	* * * *
4	Corel Draw	3	* * *
5	Tally	2	* *
6	Python	1	*

 

Even Function

 

=EVEN(A2)

 

	A	B	C
1	Number	Even
2	51	52
3	52	52
4	53	54
5	54	54
6	55	56

 

Odd Function

 

=ODD(A2)

 

	A	B	C
1	Number	Odd
2	51	51
3	52	53
4	53	53
5	54	55
6	55	55

 

Abs Function

 

=ABS(A2)

 

	A	B	C
1	Number	Abs
2	51	51
3	-52	52
4	-53	53
5	54	54
6	-55	55

 

Floor Function

 

=FLOOR(A2)

 

	A	B	C
1	Number	Floor Value
2	52.36	51
3	41.25	39
4	58.26	57
5	47.63	45
6	86.56	84

 

Ceiling Function

 

=CEILING(A2)

 

	A	B	C
1	Number	Ceiling Value
2	52.36	54
3	41.25	42
4	58.26	60
5	47.63	48
6	86.56	87