How to use If formula with Logical Operators wth Examples

If formula with Logical Operators

Today we will know, How is the IF Formula Used? For this we first need to know what are logical operators and how we have to use it.
Our logical operators are shown in the image

Our logical operators are equal to, Greater than, Less than, Greater than equal to, Less than equal to, Not equal. Which we often use in formulas.

1. If formula with Logical Operators with Logical Operators

If we want to find out whether this value is greater than 50 or not, then we will apply this formula

=A14>50 This formula will tell us whether the value written in cell A14 is greater than 50 or not. We will get its answer in TRUE or FALSE. When will the TRUE come when the condition will be our fullfill. When will the FALSE come when the condition will not be fullfill.