Choose,Large,T,Value,Areas,NPV Function in Excel

 

Choose Function

 

=CHOOSE(B2,"Red","Green","Blue")

 

Color	Rating
1	Red
2	Green
3	Blue

 

	A	B	C
1	Item	Code	Color
2	T-Shirt	2	Green
3	Hat	1	Red
4	Hoodie	3	Blue
5	Trouser	3	Blue
6	Sandel	1	Red
7	Vest	2	Green

 

Large Function

 

=LARGE($B$2:$B$7,1)

 

 

	A	B
1	Item	Qty.
2	T-Shirt	45
3	Hat	67
4	Hoodie	89
5	Trouser	90
6	Sandel	98
7	Vest	56
8	Large Am.	98

 

T Function

 

=T(A1)

 

	A	B
1	Name	Find Text Cell
2	Raman	Raman
3	1234
4	Raj	Raj
5	Karan	Karan
6	4567
7	Deepak	Deepak
8	5263
9	Radha	Radha

 

Value Function

=VALUE(B2:B8)

 

	A	B
1	Name	Find Value Cell
2	Raman	#VALUE!
3	1234	1234
4	Raj	#VALUE!
5	Karan	#VALUE!
6	4567	4567
7	Deepak	#VALUE!
8	5263	5263

 

Areas Function

 

=AREAS((B2:B8,D2:D8))

 

	A	B	C
1	Select Area	Name	Marks
2	2	Raman	48
3		Raj	75
4		Karan	85
5		Rahuk	89
6		Deepak	55
7		Kishan	96
8		Radha	74

NPV Function

 

=NPV(C7,C3:C6)+C2

 

	A	B	C
1	Year	Note	Cash Flow
2	2018	Investment	100000
3	2019	Year 1 Cash Flow	50000
4	2020	Year 2 Cash Flow	60000
5	2021	Year 3 Cash Flow	70000
6	2022	Year 4 Cash Flow	80000
7		Discount Rate(i)	5.00%
6		NPV(Net Present Value)	$412,691.09