Microsoft Excel Formula With Example

 

Excel Formula

Sum Formula in Calc

=Sum(B2:E2)

	A	B	C	D	E	F
1	Name	Hindi	Math’s	Science	Art	Total
2	Raman	78	85	63	74	=SUM(B2:E2)
3	Raj	80	86	56	75
4	Tiya	82	87	49	76
5	Hardik	84	88	63	77
6	Vikas	86	89	35	78
7	Mohit	88	90	28	79
8	Poonam	90	65	21	80
9	Ankit	92	92	56	81

 

Average Formula in Calc

=F2*100/400

 

	A	B	C	D	E	F	G
1	Name	Hindi	Math’s	Science	Art	Total	Total
2	Raman	78	85	63	74	300	=F2*100/400)
3	Raj	80	86	56	75
4	Tiya	82	87	49	76
5	Hardik	84	88	63	77
6	Vikas	86	89	35	78
7	Mohit	88	90	28	79
8	Poonam	90	65	21	80
9	Ankit	92	92	56	81

 

Percentage Formula in Calc

=Percentage(B2:E2)

	A	B	C	D	E	F
1	Name	Hindi	Math’s	Science	Art	Total
2	Raman	78	85	63	74	=PERCENTAGE(B2:E2)
3	Raj	80	86	56	75
4	Tiya	82	87	49	76
5	Hardik	84	88	63	77
6	Vikas	86	89	35	78
7	Mohit	88	90	28	79
8	Poonam	90	65	21	80
9	Ankit	92	92	56	81

 

Max Formula in Calc

=Max(B2:E2)

	A	B	C	D	E	F
1	Name	Hindi	Math’s	Science	Art	Total
2	Raman	78	85	63	74
3	Raj	80	86	56	75
4	Tiya	82	87	49	76
5	Hardik	84	88	63	77
6	Vikas	86	89	35	78
7	Mohit	88	90	28	79
8	Poonam	90	65	21	80
9	Ankit	92	92	56	81
		=MAX(B2:B9)

 

Min Formula in Calc

=Min(B2:E2)

	A	B	C	D	E	F
1	Name	Hindi	Math’s	Science	Art	Total
2	Raman	78	85	63	74
3	Raj	80	86	56	75
4	Tiya	82	87	49	76
5	Hardik	84	88	63	77
6	Vikas	86	89	35	78
7	Mohit	88	90	28	79
8	Poonam	90	65	21	80
9	Ankit	92	92	56	81
		=MIN(B2:B9)

 

Median Formula in Calc

=Median(B2:E2)

	A	B	C	D	E	F
1	Name	Hindi	Math’s	Science	Art	Total
2	Raman	78	85	63	74
3	Raj	80	86	56	75
4	Tiya	82	87	49	76
5	Hardik	84	88	63	77
6	Vikas	86	89	35	78
7	Mohit	88	90	28	79
8	Poonam	90	65	21	80
9	Ankit	92	92	56	81
		=MEDIAN(B2:B9)

 

 Mode Formula in Calc

=Mode(B2:B9)

	A	B	C	D	E	F
1	Name	Hindi	Math’s	Science	Art	Total
2	Raman	78	85	63	74
3	Raj	80	86	56	75
4	Tiya	82	87	49	76
5	Hardik	84	88	63	77
6	Vikas	86	89	35	78
7	Mohit	88	90	28	79
8	Poonam	90	65	21	80
9	Ankit	92	92	56	81
		=MODE(B2:B9)

 

Counta Formula in Calc

=Counta(B1:B9)

	A	B	C	D	E	F
1	Name	Hindi	Math’s	Science	Art	Total
2	Raman	78	85	63	74
3	Raj	80	86	56	75
4	Tiya	82	87	49	76
5	Hardik	84	88	63	77
6	Vikas	86	89	35	78
7	Mohit	88	90	28	79
8	Poonam	90	65	21	80
9	Ankit	92	92	56	81
		=COUNTA(B1:B9)

Countif Formula in Calc

=Countif(B2:B9)

	A	B	C	D	E	F
1	Name	Hindi	Math’s	Science	Art	Total
2	Raman	78	85	63	74
3	Raj	80	86	56	75
4	Tiya	82	87	49	76
5	Hardik	80	88	63	77
6	Vikas	86	89	35	78
7	Mohit	88	90	28	79
8	Poonam	90	65	21	80
9	Ankit	80	92	56	81
		=COUNTIF(B2:B9,80)

 Sumif Formula in Calc

=Sumif(B2:B9)

	A	B	C	D	E	F
1	Name	Hindi	Math’s	Science	Art	Total
2	Raman	78	85	63	74
3	Raj	80	86	56	75
4	Tiya	82	87	49	76
5	Hardik	80	88	63	77
6	Vikas	86	89	35	78
7	Mohit	88	90	28	79
8	Poonam	90	65	21	80
9	Ankit	80	92	56	81
		=SUMIF(B2:B9,80)

If Formula in Calc

=IF(G3>=85,"Merit",IF(G3>=75,"Dic",IF(G3>=65,"First",IF(G3>=45,"second",IF(G3>=33,"third","Fail")))))

	A	B	C	D	E	F	G	H
1	Name	Hindi	Maths	Science	Art	Total	Average	Merit
2	Raman	78	85	63	74	300	75	Dic
3	Raj	80	86	56	75
4	Tiya	82	87	49	76
5	Hardik	84	88	63	77
6	Vikas	86	89	35	78
7	Mohit	88	90	28	79
8	Poonam	90	65	21	80
9	Ankit	92	92	56	81

If Formula in Calc (Grade System)

=IF(G3>=85,"S",IF(G3>=75,"A+",IF(G3>=65,"A",IF(G3>=45,"B",IF(G3>=33,"C","F")))))

	A	B	C	D	E	F	G	H
1	Name	Hindi	Maths	Science	Art	Total	Average	Grade
2	Raman	78	85	63	74	300	75	A
3	Raj	80	86	56	75
4	Tiya	82	87	49	76
5	Hardik	84	88	63	77
6	Vikas	86	89	35	78
7	Mohit	88	90	28	79
8	Poonam	90	65	21	80
9	Ankit	92	92	56	81

Now Formula in Calc (Current Date and Time)

=Now()

	A
1	=NOW()
2	8/22/2022 10:56
3

Today Formula in Calc (Current Date)

=Today()

	A
1	=TODAY()
2	8/22/2022
3

Power Formula in Calc 

=Power(4,2)

	A
1	=POWER(4,2)
2	16
3

SQRT Formula in Calc (Square Root)

=SQRT(625)

	A
1	=SQRT()
2	25
3

Product Formula in Calc (Multiply in More Cell)

=Product(A1:A2)

	A
1	34
2	25
3	=Product(A1:A2)

Days360 Formula in Calc (Current Date)

=Days360("02/01/1995","07/05/2022")/365

	A
	=Days360("02/01/1995","07/05/2022")/365
	(MM/DD/YYYY)

LCM Formula in Calc 

=LCM(25,5)

	A
1	=LCM(25,5)
2
3

GCD Formula in Calc 

=GCD(25,5)

	A
1	==GCD(25,5)
2
3

MOD Formula in Calc (Remainder)

=GCD(25,5)

	A
1	==GCD(25,5)
2
3

TRIM Formula in Calc 

=Trim("AD COMPUTER                 CAMPUS")

REPT Formula in Calc 

=REPT("ADCOMPUTER",5)

LOWER Formula in Calc 

=LOWER("ADCOMPUTER")

	A
1	=LOWER("ADCOMPUTER")
2
3	adcomputer

UPPER Formula in Calc 

=UPPER("adcomputer")

	A
1	=UPPER("adcomputer")
2
3	ADCOMPUTER

REPLACE Formula in Calc 

=REPLACE("adcomputereducation",11,9,"Campus")

adcomputercampus