Rock Paper Scissors
Here we look at how to use drop-down lists, lookups and conditional formulas to teach Excel to play "Rock Paper Scissors".
Tag: Formula
Why INDEX-MATCH is better than VLOOKUP
Here we look at the many uses of the INDEX(MATCH()) combo formula, and why it is a superior replacement for the commonly-used VLOOKUP() and HLOOKUP() functions.
Calculate Time Elapsed using NETWORKDAYS()
Here we look at a formula that will calculate the duration of a project in working days, and learn how to express the % completion of a project against its target duration.
Tax Year Excel Formula
Here we look at a formula that will calculate the tax year for any given date. Ideal for Expenses forms and accounting functions.