Rand,Sumif,Trim,Subtotal,Roman,Convert,Int,Exact Function in Excel

 

Rand Function

=Rand()

 

	A	B	C	D
1	0.34629995
2
3
4
5
6
7
8

Sumif Function

Total Profit- =SUMIF(B2:B8,">0")

Total Loss- =SUMIF(B2:B8,"<0")

	A	B
1	Year	Profit/Loss
2	2016	1903384
3	2017	-878258
4	2018	-173627
5	2019	4638031
6	2020	-1892129
7	2021	1222859
8	2022	4669911
9
10	Total Profit	12434185
11	Total Loss	-2944014

 

Trim Function

=Trim(A1)

 

	A	B
1	Amit          Kumar	Amit Kumar
2
3
4

 

Subtotal Function

Total Qty.=SUBTOTAL(9,D2:D4)

 

Total Amount=SUBTOTAL(9,F2:E4)

 

	A	B	C	D	E	F
1	Item Id	Item	Brand	Qty.	Price	Amount
2	101	Mouse	Intex	10	250	2500
3	102	Mouse	Hp	10	450	4500
4	103	Keyboard	Intex	50	350	17500
5				70		24500

 

Roman Function

 

=Roman(A2,0)

 

	A	B
1	No	Roman
2	1	I
3	2	II
4	3	III
5	4	IV
6	5	V
7	6	VI
8	7	VII

 

Convert Function

 

=CONVERT(A2,"ft","in")

 

	A	B
1	Feet	Inch
2	8	96
3

 

Int Function

 

=Int(A2)

 

	A	B
1	Number	Round
2	45.5	45
3	85.63	85

 

Exact Function

 

=Exact(A2,B2)

 

	A	B	C
1	Password	Confirm Password	Result
2	John@123	John@123	TRUE
3	Vkumar123	Bkumar123	FALSE
4			TRUE
5			TRUE