|
|
|
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 accomodation to its managers based on the loaction
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 condtion 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 condtion 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'
|
|
|
|
|
|