IF statement and some variatons – nested IF, CountIF and SumIF. by David Goodmanson IF a picture paints a thousand words, then how many words have 5 characters or more? The answer? Use the IF function. The IF function is a simple and easy-to-use function that can be widely applied in the design of your […]
Details on Word & Excel updates from Office 2000 onwards plus Office for Mac. The usual security updates for Microsoft products this month include updates for Word and Excel from Office 2000 to Office 2007 plus Office for Mac. Security holes in Word’s text converter and Excel headline this month’s patches plus some for our […]
Let’s have some INDEX() and MATCH() fun in our Lookup function series. by David Goodmanson On their own, the INDEX() and MATCH() functions are fairly straightforward but when they are combined they create a very powerful Lookup tool. Both functions have 3 parts to their arguments. INDEX(range, row_number, column_number) and MATCH(lookup_value, range, match_type) Let’s use […]
How to print a document when the paper sizes are different. On our new Twitter account we saw this question: “When I send an Excel file to someone, should I have to set it up so they can print? I don’t know the printer/size they use.” Part of that answer is preparing the document but that’s […]
Using Vlookup in Excel to work out tax, fees or commission from a table by David Goodmanson In part 1 we covered the basics of VLookup, let’s use it to calculate tax for a list of employees and their salaries. We’ve chosen this practical example because it contains a fixed amount plus a marginal percentage […]