How to create a formula to check whether a number is within the range and how to grade it into categories?

You may use IF function in the data. The If function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.

The syntax for the If function is:

If( condition, value_if_true, value_if_false )

• condition is the value that you want to test.

• value_if_true is the value that is returned if condition evaluates to TRUE.

• value_if_false is the value that is return if condition evaluates to FALSE.

Let’s take a look at an example: Continue reading →