If the value of A is equal to 20, he is on probation. We’ve also changed our formula for the “Status” column a little. If the value of A is not equal to 20, then the student is not on probation. We add a third column called “Probation”, and paste this formula into all rows =IF(A#20, “No”, “Yes”) As you can see, the formula is a little tricky. You can assign that status using the not equal to comparison operator. Suppose that you want students who have received 20 out of 50 on their exams to be put on probation. We apply the formula =IF(A4” together. The general syntax of the not equal to operator is: =IF (cellname condition, result 1, result 2)
You can ask excel to display “Student has failed” if the value of the “logical_test” turns out to be false.Įxample: We name our column “A” as Marks and column “B” as Status. The “value_if_false” lets you decide what happens if your condition is failed. You can ask excel to display “Student has passed” if the condition is met. For example, did the student score less than 20 marks? The “value_if_true” part lets you decide what happens if your condition is passed. If a student gets more than 20, he passes. The syntax for the IF function is: IF (logical_test, )Įxplanation: The “logical_test” is where you provide the condition using the comparison operators. If a student gets less than 20 out of 50, he fails. For example: you can create an Excel spreadsheet for your school to help you see how the students fared this semester. You will see it used a lot in a typical work environment. This will help you grasp the concept of the “not equal to” comparison operator better. If you pair it with the IF logical function, you can create all kinds of complex queries. But before we get to the not equal to comparison operator, we’ll take a quick look at the syntax of the IF function.
The symbol for the not equal to comparison operator is “”. In this tutorial, you’ll get to learn about the Not Equal to Comparison operator. Excel is pretty intuitive and a basic course in Excel should be enough to get you started. The differences between Excel 2007, 20 are cosmetic and so you can use any one of the three you have access to. We’re assuming that you’re at least slightly familiar with MS Excel.
We’re going to be using MS Excel 2013 for our tutorial. Some of these operators include the equals operator (=), the less than operator (), the less than or equal to operator (=) and finally the not equal to () operator. Microsoft Excel provides comparison operators that can be combined with functions, which will allow you to automate certain data calculations. You can use functions, graphical charts, tables and some data analysis tools to make your data presentable and understandable. Excel provides you with various tools that you can use to handle data and sort it. With Microsoft Excel, you can store and work with a large database.
Microsoft Excel is a spreadsheet software that’s a part of the iconic Microsoft Office software.