All If Function in Excel

 All If Function

Iferror Function

=IFERROR(VLOOKUP(A2,Sheet1!A1:C6,2,FALSE),"Not Found")

 

	A	B
1	ID	Name
2	103	Priya

 

	Sheet 1
	A	B	C
1	ID	Name	Age
2	101	Aman	25
3	102	Deepak	32
4	103	Priya	27
5	104	Anjali	33
6	105	Rohit	32

 

 

 

 

 

 

 

 

   

Dget Function

	A	B	C	D
1	Emp. ID	Name	Region	Sale
2	101	Amit	Agra	15000
3	102	Rajeev	Delhi	30000
4	103	Manoj	Mumbai	25000
5	104	Deepak	Nagpur	35000
6	105	Nakul	Delhi	40000
7	106	Yamini	Mumbai	36000

 

	A	B
1	Emp. ID	Sale
2	102	30000

 

=DGET(A1:D7,”Sale”,A1:A2)

 

	A	B
1	Emp. ID	Sale
2	102	30000

 

=DGET(A1:D7,4,A1:A2)

 

	A	B	C	D
1	Emp. ID	Sale	Name	Region
2	102	30000	Rajeev	Delhi

 

=DGET($A$1:$D$7,B1,$A$1:$A$2)

 

If Function

	A	B	C	D
1	S.Name	Marks	Pass/Fail
2	Name 1	54	Pass
3	Name 2
4	Name 3
5	Name 4

=IF(B2>40,"Pass","fail")

 

If Function

=IF(B2<18,"Not Eligible For Voting”,“Eligible For Voting")

 

	A	B	C	D
1	Voter Name	Age	Eligible for Voting
2	Name 1	34	Eligible For Voting
3
4
5

 

If Function

=IF(A2=B2," ","Doesn't Match")

 

	A	B	C	D
1	Bank A/C No.	Passbook A/C No.	Status
2	1210012	12120012	Doesn't Match
3
4
5

 

If Function

=IF(B2>40,"A"," ")

 

	A	B	C	D
1	S.Name	Marks	Fail/Student
2	Name 1	85	A
3
4
5

 

If Function

 

=IF(B2<40,B2+5," ")

 

	A	B	C	D
1	S.Name	Marks	Add Grace Marks
2	Name 1	54
3	Name 2	38	43
4
5

 

If Function

=IF(B2<15000,B2+B2*10%," ")

 

 

	A	B	C	D
1	E. Name	Salary	Increment 10% if Salary<15000
2	Name 1	14000	15400
3
4
5

 

If Function

 

=IF(C2>=80,"A",IF(C2>=60,"B",IF(C2>=40,"C","D")))

 

	A	B	C	D
1	Condition	Grade	Total Marks	Grade
2	>=80	A	87	A
3	60-79	B	56	C
4	40-59	C	45	C
5	<40	D	21	D