Tag Archives: IF

Nested IF vs. VLOOKUP – Which one to use?

A well-drawn flowchart or a well-organized table helps you write a successful formula effectively Continue reading

Rate this:

Advertisements
Posted in Excel Tips | Tagged , , | 4 Comments

IF, it is too complicated…

Writing an IF function is quite straight forward, if there is only one logical test involved. For example, we want to comment on a shop’s performance by looking at its actual sales. If Actual hits Budget, then Good job, else … Continue reading

Rate this:

Posted in Formula | Tagged | 12 Comments