• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer

Computer Notes

Library
    • Computer Fundamental
    • Computer Memory
    • DBMS Tutorial
    • Operating System
    • Computer Networking
    • C Programming
    • C++ Programming
    • Java Programming
    • C# Programming
    • SQL Tutorial
    • Management Tutorial
    • Computer Graphics
    • Compiler Design
    • Style Sheet
    • JavaScript Tutorial
    • Html Tutorial
    • Wordpress Tutorial
    • Python Tutorial
    • PHP Tutorial
    • JSP Tutorial
    • AngularJS Tutorial
    • Data Structures
    • E Commerce Tutorial
    • Visual Basic
    • Structs2 Tutorial
    • Digital Electronics
    • Internet Terms
    • Servlet Tutorial
    • Software Engineering
    • Interviews Questions
    • Basic Terms
    • Troubleshooting
Menu

Header Right

Home » Excel » How to use if condition in excel
Next →
← Prev

How to use if condition in excel

By Dinesh Thakur

Excel if statement is a decision making statement. It is defined as a function which checks that given condition is true or false. If it’s true it will execute true statement otherwise it will execute false statement. if formula in excel is:

If condition then true else false

Excel If statement:Excel If statement works same as programming language if statement.

We’ll be covering the following topics in this tutorial:

  • Syntax of Excel IF Statement
  • Syntax of Excel Nested IF Statement:

Syntax of Excel IF Statement

The syntax of If Function in Excel is as follows:

=IF (Logic_Test, Value_if_True, Value_if_False)

For example:

Basic excel if statement

In IF(B5<40, “Fail”,”Pass”) statement explain that if value of Cell B5 is less than 40 than Rohit is fail otherwise he will pass. But Rohit’s marks is not less than 40 so result is pass.

*Nested if statement: Nested If used to test more than one condition at a particular time. In ‘nested if ‘ conditions are packed in one another to execute in a sequence manner. ‘Nested If’ in logical flow:

Syntax of Excel Nested IF Statement:

=IF(Logic_Test(1), Value_if_True,IF(Logic_Test(2), Value_if_True,IF (Logic_Test(3), Value_if_True, Value_if_False)))
In ‘Nested If’ system will execute  Logic_Test(1) statement .Suppose to result is false then logic_Test(2) will executed. Now Condition is true value will be printed and nested if will more execute.  To understand it more clearly let discuss an example.

Basic if assing grade

In this example: We have Name, Marks and Grade column. We want to assign grade according to their marks in subject. We are assigning  grade ’A’ who are getting marks more than 90.Grade ‘B’ who are getting less than 90 . Similarly, We are giving C,D and F grade.
*Condition in Formula Bar explaining that cell B4 value=40
 If (40 is less than 60) ——Which is true
    Then Grade ‘F’ is assigned.
*Lets talk about how nested if will work for cell B7 value=95
 If (95 is less than 60) ——Which is False
    Then (If (95 is less than 70) Again Condition is False
         Then ((If (95 is less than 70))) Again Condition is False
         Then (((If (95 is less than 90)))) Again Condition is False because 95>90

Grade ‘A’ is assigned to  Loveleen.

Grade in IF Excel provides us Evaluate Formula to show that how statement will execute. Let us discuss example to assign the grade to ‘Rohit’ using above figure data. Evaluate function first check (70<60) which get false then click on evaluate.

evaluate Formula in if condition

 Then second statement will checked by system. It is false then last one checked.

evaluate Formula IF

You’ll also like:

  1. How to use the countif function in excel
  2. how to make a excel graph.
  3. Working with Excel 2010
  4. Python Condition Statement
  5. MySql Null Condition in Java Servlet
Next →
← Prev
Like/Subscribe us for latest updates     

About Dinesh Thakur
Dinesh ThakurDinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps.

Dinesh Thakur is a Freelance Writer who helps different clients from all over the globe. Dinesh has written over 500+ blogs, 30+ eBooks, and 10000+ Posts for all types of clients.


For any type of query or something that you think is missing, please feel free to Contact us.


Primary Sidebar

Excel 2010

Excel 2010 Tutorials

  • Excel - Started
  • Excel - Tour
  • Excel - BackStage View
  • Excel - Entering Values
  • Excel - Navigating Workbook
  • Excel - Save Workbook
  • Excel - Open/Close Worksheet
  • Excel - Managing Worksheet
  • Excel - Managing Data
  • Excel - Rows & Columns
  • Excel - Copy & Paste
  • Excel - Find & Replace
  • Excel - Spell Checker
  • Excel - Zoom In/Out
  • Excel - Paginated View
  • Excel - Insert Comments
  • Excel - Insert Text Box
  • Excel - Undo/Redo
  • Excel - Formatting Cells
  • Excel - Formatting Worksheets
  • Excel - Working with Formula
  • Excel - Quick Access Toolbar
  • Excel - Name Field
  • Excel - Formula Bar
  • Excel - Status Bar
  • Excel - Full Screen Mode
  • Excel - Grid and Indexing Fields
  • Excel - Preferences Window
  • Excel - Color Scheme

Ribbon Tab

  • Excel - Ribbon Tabs
  • Excel - Show and Hide Ribbon
  • Excel - Adding Ribbon Groups
  • Excel - Active Label of Ribbon Group
  • Excel - Customizing the Ribbon
  • Excel - Contextual Ribbon Tabs

Other Links

  • Excel - PDF Version

Footer

Basic Course

  • Computer Fundamental
  • Computer Networking
  • Operating System
  • Database System
  • Computer Graphics
  • Management System
  • Software Engineering
  • Digital Electronics
  • Electronic Commerce
  • Compiler Design
  • Troubleshooting

Programming

  • Java Programming
  • Structured Query (SQL)
  • C Programming
  • C++ Programming
  • Visual Basic
  • Data Structures
  • Struts 2
  • Java Servlet
  • C# Programming
  • Basic Terms
  • Interviews

World Wide Web

  • Internet
  • Java Script
  • HTML Language
  • Cascading Style Sheet
  • Java Server Pages
  • Wordpress
  • PHP
  • Python Tutorial
  • AngularJS
  • Troubleshooting

 About Us |  Contact Us |  FAQ

Dinesh Thakur is a Technology Columinist and founder of Computer Notes.

Copyright © 2025. All Rights Reserved.

APPLY FOR ONLINE JOB IN BIGGEST CRYPTO COMPANIES
APPLY NOW