In this video I show you how to calculate a location allowance but only when certain conditions are met – the Ref number has to be higher than a certain figure and it’s only paid when the employee is from one of four departments. However it also has to be adjusted to add up the numbers from two columns…. You can download the completed file here.
Excel shortcut keys – FREE
Recent Posts
Categories
- Excel – From The Beginning
- Excel Formulas | Essential formulas
- Excel Formulas | Essential Functions
- Excel Functions | Useful
- Excel Lists | List basics
- Excel Lists | Sorting and Filtering
- Excel Pivot tables | Introduction
- Excel | Advanced Lessons
- Excel | Case Studies
- Excel | Conditional Formatting
- Excel | Excel Beginner Lessons
- Excel | Excel for Small business
- Excel | General
- Excel | Intermediate Lessons
- Excel | Useful tricks
- Personal
- Powerpivot 2010
- Training Records Management
- Using Excel for tracking training