Starting today, i will be posting MS Office tips periodically. This first tip is on how to implement the Microsoft Excel “IF” formula. This tip works in all Excel versions.

Let’s assume that you manage a sales operation in five cities: New York, San Francisco, Amsterdam, Paris and Tokyo. For each city you have a sales quota and an actual sales amount. You would like to quickly determine for each city if your actual sales amount exceeded the quota:

We will use the “IF” formula. The syntax is as following:IF(logical test, value if true, value if
false).

How to implement:

1. Create column D, named “Actual sales exceeded Quota?”.

2. In cell D2 type =IF(C2>B2,”YES”,”NO”).

3. Apply the formula on cells D3 to D7.

4. Result will look as following:

Enjoy!

[tags] Excel formula, Excel [/tags]