Learning how to learn excel’s if function in Excel is one of the basic things you need to master when working with spreadsheets.
The IF Function is an automatically embedded logical function within Excel that is classified as a text box function.
Two Types Of If Function
How to use IF Function in Excel. IF Function can only be used as a cell function in Excel, so it is automatically included as part of the Worksheet’s cell.
There are two kinds of IF functions, one is logical and the other one is the nesting one.
Logical If Function
The logical one is a very simple one that compares two different values, if both of them is equal to True then the result is True Customised Training Solutions.
On the other hand, the nesting one is a more complex one where you can define multiple comparisons and the result will always be True if both of them are True.
In the logical test, the first cell reference must be the same or equal to the second cell reference.
Second Cell Reference
The second cell reference can either be greater than the first one and exactly equal to the third one. If the first cell reference is equal to the second cell reference, then the result is False.
But, if both of them are false, then the result is True.
There are other two types of IF functions. One is the constant IF function which has arguments that are constant and cannot be changed.
The other one is the conditional IF function that allows changes on the arguments. To know the difference between these two functions, just take a look at the example below.
Examples Of If Function
You will know better how to learn Excel once you get familiar with these two types:
Nested IF is similar to logical test but only allows nesting of two or more IF Statements. The syntax of this is simple as well.
The main difference between the two types of IF functions are that the nesting of two IF statements can refer to different rows or columns.
Nested If Function
In the case of a logical test, the names of the cells being tested do not need to be the same as the names of the arguments. The following code shows the usage of nested-IF:
Another IF function called Greater than is similar to logical operators in Excel. Such as AND, OR, and NOT. This IF function allows for comparison between the values.
The syntax of this is very simple as well: the first argument here can be any valid floating-point value.
The second argument here is the actual value to compare. The result is always True.
One more IF function called Greater than and Less than can be used to compare two numeric arguments using both single and double-quotes.
The syntax is pretty much the same as the rest of the other IF functions. The main difference between the other two is that here there are two sets of arguments.
The first set refers to the numeric arguments to be compared. The second set includes the references to these arguments within the double-quotes.
The logic here is that if the first expression is greater than the second one, so will the second one be evaluated.
One more IF function called Greater than or Less than can be defined as follows. If the second argument contains a logical test, then the result will be False.
The syntax for this is pretty much the same with all other types of IF functions.
Logic of If Function
The logic behind this check is that the second argument to the IF operation must evaluate to a truthful value such as True or False.
Any other expression will be considered false. To learn more about other types of logical tests, such as TRUE and FALSE.
As well as others that may be found in this article, you should look at some of the many articles on this topic on the internet.
