- Excel Tutorial
- Excel Introduction
- Excel Addition(+)
- Excel Subtraction(-)
- Multiplication(*)
- Excel Division(/)
- Excel IF Function
- Excel SUMIF
- Count & CountIF
- Excel IFerror
- Excel Pivot Table
- Move Pivot Tables
- Excel Drop-Down list
- Conditional Formatting
- Excel Hyperlink
- Excel Vlookup
- Excel Hlookup
- Excel Protect Sheet
- Excel Macros
- Excel Insert Images
- Excel Concatenate
- Excel Text To Column
- Remove Duplicates
- Excel Cell Formatting
- Group in Excel
- Excel Comments
- Excel Freeze Panes
- Excel Charts
- Print in Excel
- Excel Transpose
- Reminders in Excel
- Reduce Excel File Size
- Percentage in Excel
- Substitute Function
- RANK Function
- ROUND Function
- Cell References
- Date Function
- Text Functions

EXCEL FORMULAS Excel Tutorial Excel Introduction Excel Addition(+) Excel Subtraction(-) Multiplication(*) Excel Division(/) Excel IF Function Excel SUMIF Count & CountIF Excel IFerror Excel Pivot Table Move Pivot Tables Excel Drop-Down list Conditional Formatting Excel Hyperlink Excel Vlookup Excel Hlookup Excel Protect Sheet Excel Macros Excel Insert Images Excel Concatenate Excel Text To Column Remove Duplicates Excel Cell Formatting Group in Excel Excel Comments Excel Freeze Panes Excel Charts Print In Excel Excel Transpose Reminders in Excel Reduce Excel File Size Percentage in Excel Substitute Function RANK Function ROUND Function Cell References Date Function Text Functions

IF in Excel | IF Syntax | Examples | IF Greater Than | IF Equal To | IF Less Than or Equal To

IF condition in Excel is a logical function that is used to satisfy the user's given condition.

It means using the IF condition function we can return one value if a condition is true and another value if it's false.

In other words, the IF Excel function checks whether a condition has been met, and then it returns one value if true and another value if false.

IF function in Excel plays a major role in logical conditions.

Ex: =IF(A1>=70,"First Class","Second Class")

In the below given example, we have discussed multiple IF conditions for better understanding.

In the below given example, we have student names with their percentage of marks. and we need to find the grades of the students depending upon their percentage.

Using the IF condition function, it is easy to find the grades of the students.

Condition:- __If any student marks % is greater than 70 then it considered as "First Class" Or it considered as "Second Class".__

Execute the below steps to get a result,

1. Put the cursor on cell C2.

2. Apply the IF function.=IF(B2>70,"First Class","Second Class").

Explanation: if cell B2 is > (greater than) 70, then First Class or Second Class.

3. Drag the formula to all remaining cells.

let's take one more example, in the below example we have state name and demo name columns with data.

Here the task is, using the IF function we need to find whether the state name is equal to the demo name or not.

Condition:- __State name and Demo name is equal or not.__

Execute the below steps to get a result,

1. Put the cursor on cell C9.

2. Apply the IF function.=IF(B9=A9,"Name Matched","Not Matching").

Explanation: if cell B9 is=(equal to) cell A9, then "Name Matched" or "Not Matching".

3. Drag the formula to all remaining cells.

In the below example, we have the Product name, MRP columns with data, here the task is, using the IF function we need to find Best Price and High Price.

Condition:- __Any product has MRP less than or equal to 35 then it considered as Best Price or High Price.__

Execute the below steps to get a result,

1. Put the cursor on cell C18.

2. Apply the IF function.=IF(B18<35,"Best Price","High Price").

Explanation: if cell B18 is < (less than) or=(equal to) 35, then it considered as a "Best Price" or "High Price".

3. Drag the formula to all remaining cells.

Note: Always use the double quotes to Specify text in if condition.

- Transpose in Excel.
- Percentage in Excel.
- Conditional Formatting in Excel.
- How to use Vlookup in Excel?
- How to use Charts in Excel?

Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.

0 Comments

To Learn:

Tutorials in a simple Way.

Excel with downloadable samples.

HTML with sample website code.

PowerPoint presentations.

MS Word for offical use.