### VBA Projects

###### Full Access with Source Code
• Designed and Developed by PNRao

• Full Access with VBA Source Code

• Well Commented Codes Lines

• Creative and Professional Design

#### 120+ Project Management Templates

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

###### 120+ PM Templates Includes:
• 50+ Excel Templates

• 50+ PowerPoint Templates

• 25+ Word Templates

Share Post

## What is the use of IF function?

IF Function in Excel helps us to check a condition, it returns one value if a specified condition is TRUE, or another value if the condtion is FALSE

### What is the syntax of IF function?

IF( logical-text,

[value_if_true], [value_if_false] )

logical-text: it is a condition to test
[value_if_true]: value to be returend if the condition is satisfying/True
[value_if_false]: value to be returned if the condition is not satisfying/False

### IF Function in Excel – Examples

Example 1: Returns “Fine” as the salary is not more than 2000
This example IF formula is checking if B14 cell values is greater than 2000 or not, it is printing as “Fine” as the cell value (2000) is not greater than 2000.

Example 2: Returns “Exceeded” as the salary is more than 3500
This example IF formula is checking if B15 cell values is greater than 3500 or not, it is printing as “Exceeded” as the cell value (4000) is greater than 3500.

Example 3: Returns “Fine” as the salary is more than 10000
This example IF formula is checking if B16 cell values is greater than 10000 or not, it is printing as “Fine” as the cell value (8000) is not greater than 10000.

### Examples on IF With AND

Example 4: Returns “Fine” as the both conditions are satisfying
Example 5: Returns “Fine” as the both conditions are satisfying
Example 6: Returns “Exceeded” as the second condition is failing

### Examples on IF With OR

Example 7: Returns “Good” as the both conditions are not satisfying
Example 8: Returns “Good” as the both conditions are not satisfying
Example 9: Returns “Not Good” as the second condition is satisfying

### Examples on Nested IF Conditions

Example a: Returns “Less” as the first condition is satisfying
Example b: Returns “Less” as the second condition is satisfying
Example c: Returns “Less” as the third condition is satisfying

### VBA example on IF function

IF function is also available in VBA, following is the example code:

Dim sOuput as String
Dim iVal as Integer
iVal=2000
If iVal < =3500 Then sOutput="Good" Else sOutput="Not Good" End If

Output: sOutput=Good

### Reference:

Please refer the below article for more Logical Excel functions.
Logical Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

Effortlessly Manage Your Projects and Resources
120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Save Up to 85% LIMITED TIME OFFER

###### Project Portfolio Management Templates
Categories: Excel FormulasTags: Last Updated: June 17, 2022