- Home
- IF Statement
Simplify IF AND OR eBook
My second eBook is almost ready! It is now being reviewed and will be available soon to all subscribers. This time around we look at IF AND OR functions – these are areas where I am frequently being asked for help to clarify.
Continue readingVLookup with multiple values
So, you can use a VLookUp to retrieve a piece of information. You can use SumIf to total a range based on criteria and you can use CountIf to count how many times criteria appears. What do you do though when you have to create a VLookUp with multiple values? The VLookUp will run through […]
Continue readingCreate A Planner In Excel
It’s that time of year again when I start receiving requests for help with creating planners for the new year. These planners are usually for teams or groups to organise holiday schedules and rosters. This year I created a reusable planner that can be used in future years and also includes most of the features […]
Continue readingIFERROR
The IFERROR formula in Excel returns a value you specify if a formula results in an error, if there is no error it returns the value of the original formula. The IFERROR function is relatively new to Excel (I believe it started in Excel 2007). For a similar workaround to some VLOOKUP formula error results, […]
Continue readingSUMIF
The SUMIF formula is a really useful formula for adding the values in cells based on set criteria. This post will build on what you have seen already in the IF Statements post and will use the example of game scores. To demonstrate this, we will use an example of a list of scores each […]
Continue readingIF Statements
IF statements are usually thought relatively early in Excel courses soon after addition, subtraction, multiplication, etc. For this reason I guess a lot of people consider them to be “basic” formulas. However, you would probably be surprised by the number of questions I get about IF statements. Some people don’t fully understand them or find […]
Continue reading