The ‘IF’ function in Excel – probably the most versatile function
The IF function in Excel can help solve many problems. With ‘if’ you can perform calculations with Excel data based on defined conditions and you can analyze excel data based on set criteria. Therefore, using ‘if’ helps you analyze and calculate the data according to the problem definition. Let’s say a company provides a certain quality of accommodation to its managers based on the location like a small city or large metro. A teacher may wish to assign a grade to her students based on the total marks they have obtained. An employer may wish to give a bonus amount based on the sales amount in a quarter and so on. Using the if function you could easily extract or calculate the values.
Implementation of the function
- Start by typing ‘=’ in the cell where you want the result
- Then type ‘if’ followed by a ‘(‘ and type your condition like’c2=”GM”‘
- Next define a value if the condition is true after a ‘comma’ like ‘b2*100%’
- Follow this with a ‘comma’ and define the value like ‘b2*50%’ if the condition is false
- In plain English, you actually told the Excel program to print the value if your defined condition is true, else print another defined value, if the condition is not true
- Text conditions like ‘GM’ have to be defined as “GM” with the double quotes. Numbers are defined without quotes.
- Refer to the Excel training video for a demonstration of the concept of ‘if’
MS Excel: IF Function (WS)