Excel - IF function
- Whether the criteria is met
- Return a value based on whether the criteria is met or not. If the criteria is met, it returns one value; if the criteria is not met, it returns a different value.
In the following example, there are 5 employees, each having his own budget. Column C records the exact amount of money they spent. If the actual spending is greater than budget, we call it "Over budget", otherwise, we call it "Within budget". The IF function is:
=IF(C2>B2,"Over budget","Within budget")
Comments
Post a Comment