The AND function AND Function The AND function in Excel is classified as a logical function it returns TRUE if the specified conditions are met, otherwise it returns FALSE. We use the MOD function to find a remainder after a dividend is divided by a divisor. In this example, we will use the IF function along with the AND, OR, and MOD functions to find the leap years. The year will be exactly divisible by 400.The year will be exactly divisible by 4 and not exactly be divisible by 100 or.The criteria for a leap year are stated as follows: We want to find out if the given year is a leap year or not.Ī leap year has 366 days the extra day is the 29th of February. The following table shows a list of years. The modus operandi of the IF function is stated as: If something is true, then do something otherwise, do something else. Hence, the IF excel function allows making logical comparisons between values. Let us understand the working of the IF function with the help of the following examples in Excel. Depending on whether the condition matching is true or false, these operators return the output.

The following table shows the different logical operators Logical Operators In Excel, logical operators, also known as comparison operators, are used to compare two or more values. The IF formula uses logical operators to evaluate the values in a range of cells.

In the formula, the “logical_test” is a required argument, whereas the “value_if_true” and “value_if_false” are optional arguments.

Value_if_false: It is the value returned as a result when the condition is “false”.

Value_if_true: It is the value returned as a result when the condition is “true”.The condition can be a value or a logical expression. Logical_test: It refers to the condition to be evaluated.The IF excel function accepts the following arguments: The syntax of the IF function is shown in the following image: It is often used to make logical interpretations which help in decision-making. The IF excel function returns “value B” if condition A is met and returns “value C” if condition A is not met. IF function in Excel evaluates whether a given condition is met and returns a value depending on whether the result is “true” or “false”. It is a conditional function of Excel, which returns the result based on the fulfillment or non-fulfillment of the given criteria.įor example, the IF formula in Excel can be applied as follows:

What are in excel formulas