Microsoft Excel Training Videos
The 'IF' function in Excel - probably the most versatile function.
The 'if' function in Microsoft Excel can help help solve many problems. With 'if' you can calculate 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.
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 met
Text conditions like 'GM' have to be defined as '"GM"' with the double quotes. Numbers are defined without quotes.
Refer to the training video below for a demonstration of the concept of 'if'
Microsoft Excel Training Videos
