< Go Back

If cell is greater than

We can check if the cell is greater than some value, very easily using the excel’s IF() function.

What is IF()?

If we want to evaluate some condition in excel, we can achieve that by using the IF() function.

The IF() function returns true if a condition is met and false otherwise.

Formula

=IF(cnd)

“cnd” in the formula represents some condition that would get evaluated.

How to use the Formula to check if a cell is greater than?

Figure 1. Example 1 of IF() to check if a cell is greater than

In this example, we created a small table containing students information. We want to apply IF() on this table to see if the marks are greater than 50. Let’s see how you can do that.

  1. Select any column, where you want to display the status of a particular student. In this case, we selected H10.
  2. Go in the function box and type IF FUNCTION.
  3. Give the arguments i.e. the condition. For H10 column we gave G10>50,”Pass”,”Fail”.
  4. If the condition is true, Pass will be written in H10 cell, Fail otherwise.
  5. You can observe in the column H10 that status is “Fail”. This is because G10 cell has a value of 47, which is less than 50.

Alternative Way of Checking If the cell is greater than any other cell

Figure 2. Example 1 of “>” to check if a cell is greater than

We can also check if a cell is greater than any other cell without using IF() Function. Here is an example using the “>” operator. The logical operator “>” gives either true or false.

In this example, we are comparing the prices of Item1 and Item2.

  1. Select any column, where you want to display the status for a particular item. In this case, we selected I35.
  2. Go in the function box and type G35>H35.
  3. If Item1 has a larger price then “True” will be printed out, “False” otherwise.
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar