As we know very well in MS-Excel user can enter four types of data i.e. text, numeric, formula and logical formula.

                        Logical formula means that formula where user can define the condition and computer returns result after match the condition.

            There are following formulas: -

If(): -It is a type of logical formulas which determine the condition is true / false one value display the condition is true and one value return the condition is false.

                                    Syntax: -=If(condition,”pass”,”fail”)

	A	B	C	D	E	F	G	H	I	J
1	ROLL	NAME	PHY	CHE	MATH	TOTAL	PER	PASS/FAIL	DIV1	DIV2
2	1	RAJ	90	78	65
3	2	RAJU	78	90	87
4	3	MOHAN	56	78	89

Q.1.    Calculate for pass total should be greater than 200

                        =If(F2>=200,”Pass”,”fail”)

Q.2.    Calculating division

                        >=60%         -           First

                        >=45%         -           Second

                        >=30%         -           Third

                        Otherwise   -           Fail

           

=If(G2>=60,”First”,If(G2>=45,”Second”,If (G2>=30,”Third”,”Fail”)))

Q.3.    Subject Wise

=If(And(C2>=30,D2>=30,E2>=30,G2>=60),”First”,If(And(C2>=30,D2>=30,E2>=30,G2>=45),”Second”,If(And(C2>=30,D2>=30,E2>=30,G2>=30),”Third”,” Fail”)))

A	B	C	D
1	COURSE	NAME	FEE
2	DCA	MOHAN	3250
3	ADCA	SOHAN	8000
4	DOA	RAJ	5000
5	DOA	RAHUL	4900
6	ADCA	AMAN	7500
7	DOA	IRSHAD	4800
8	DCA	ANAND	2750
9	DCA	RAJA	2500
10	ADCA	RAJEEV	7000

Sumif(): -This Logical Function is used to sum numerical cells range value according to specified condition by the user.

Syntax: - =Sumif(Range to check,”Criteria”, Range to total)

Ex: -               =Sumif(B1:B11,"DCA", D1:D11)

 Countif(): -This function is used to count the number of cells which satisfies the condition.

                                    Syntax: -       =Countif(Range to check,”Criteria”)

                                    Ex: -               =Countif(B1:B11,”Dca”)