Skip to content

Excel AutoComplete Suggestions From Lists by Oheen

Best Excel AutoComplete Suggestions Tool

X
  • Contact
Menu

How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016…

Posted on January 5, 2018May 15, 2019 by exceladmin

Simply put, a condition in Excel can be either true or false. For example, 1 > 0 is a condition that is true while 1 < 0 is false. In Excel, there are many times that you need to evaluate a condition in order to decide what to do next. For example, you want to  check the years that a certain employee has been working for you company to decide the number of days off per year that person is allowed to have, you will need to evaluate a value called working period as the example below:

As you can see, the column F contains the number of working period of our employees. The logical test is:

If (Working Period > 20)

If the condition is evaluated to true, then it the days off per year will be 40, otherwise, the number would be 10.

You may wonder, what if I want to have a more complex condition? Can I have more than 2 results, such as if the number of working period is bigger than 10, the days off would be 10, if it’s less than 10, the days off would be 5.

In such case, you may need to nest the IF function as below:

excel nested if condition

As you can see, there are two IF functions test two different condition. The first condition is still if the working period is > 20. However, the value_if_false of the outer is not a single value anymore, it’s another IF function. The condition of the inner IF is to test if the working period is more than 10, if the condition is true, the number of days off is 10, otherwise, it’s 5. You can build a very complex condition using this logic.

So, that’s how you use conditions in Excel. Most of the time, you will use condition with the IF function. You can build a simple condition or a very complex one, depends on your need.

If you find the post helpful, please share it. Thanks!

Posted in Excel tipsTagged excel condition, excel tips, if function

Post navigation

How To Extract Parts of Date In Excel
How To Check If Multiple Conditions Are Met In Excel

Related Post

  • How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016… How To Check If Multiple Conditions Are Met In Excel
  • How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016… How To Extract Parts of Date In Excel
  • How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016… How To Count Number Of Days, Years, Months… Between Two Dates In Excel
  • How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016… How To Extract Parts Of Text String
  • How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016… How To Remove Leading And Trailing Space From Text String In Excel
  • How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016… Excel Tip 2: How To Move To The Beginning And The End of The Data Table In Excel
  • How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016… Excel Tips 1: Double Click To Copy Formula
  • How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016… How to include double quotes in Excel formulas?
  • How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016… How To Turn Excel Into CSV With UTF-8 Support

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Contact Support

If you need support, please click below

Recent Posts

  • How To Check If Multiple Conditions Are Met In Excel
  • How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016…
  • How To Extract Parts of Date In Excel
  • How To Count Number Of Days, Years, Months… Between Two Dates In Excel
  • How To Extract Parts Of Text String
  • How To Remove Leading And Trailing Space From Text String In Excel
  • Excel Tip 2: How To Move To The Beginning And The End of The Data Table In Excel
  • Excel Tips 1: Double Click To Copy Formula
  • How to include double quotes in Excel formulas?
  • How To Turn Excel Into CSV With UTF-8 Support
Theme Design & Developed By OpenSumo
  • Contact
  • Excel Autocomplete From List