The IF function in Excel use different arguments and then return with a value. There is a value that return when the user's specified terms are evaluated to be true, and another value will return, when the condition is false.
Parameter and Arguments
This is how the IF function's formula looks like: IF(logical test,value if true,value if false)
Logical test: This is required. The test that a user wants the function to perform.
Value if true: This is optional. It would be the value that a user wants to return, when/if the logical test argument is true. If it is omitted, it would return with "true".
Value if false: This is option. It is the value that should return, if a logical test is false. If omitted, "false" would return.
Example 1: Simple IF Formula
This sample is about acknowledging the information that would help the comprehension of a simple IF formula. In this case, we want to know the amount we make from selling a specific product.
Example 2: IF and Average
This is an example that simultaneously uses both the average and if formula.
Example 3: IF and SUM
Usage The issue here is that we would like to know how much the company would make, at a level that addresses the total amount that the company would make, in combination with the quantity of products that we'd have in the inventory.
Example 4: Double IF in one Formula
The formula here is about using two IF formulas together.
Example 5: IF, AVERAGE and SUM in one Formula
This example focuses on combining 3 different formulas into 1 to find a result.
Example 6: IF, MIN and MAX
This example use IF, MIN and MAX formulas to find the answer.
Example 7: IF and Date
This is the usage of IF and Date formula. This sample focuses on how much we've made today, if we only focus on a specific price.
Example 8: Double IF in one Formula
This example use two IF formula, because we would like to start a new project that would allow us to cleanse our remaining inventory. It was intended that in the event that we have not sold all the products after a specific period of time, we were going to sell it for a specific amount of money. Usage of double IF formula allow productivity to help determine how much we would make from selling it in a specific project.
Example 9: Net Worth after Expenses
We want to know the profit we would make after paying all expenses, and selling the products at a specific price. This is where we would be using double IF formulas and SUM.
Example 10: SUM and IF
This is the usage of both functions: sum and if – and find the answer that we are looking for.