by admin | Mar 22, 2021 | Excel | General
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...
by admin | Feb 1, 2021 | Excel | Case Studies
In this blog post I walk you through a number of different ways to tackle a question. I had a user who had to identify the correct rate for something based on country of origin and product type. You can download the completed file here. Watch the video here to see how...
by admin | Oct 12, 2020 | Excel | General
Quite often I get people asking me how to do X or Y and this video addresses how Excel would be used to identify what is early, late and on time – assuming a 10 day buffer (either side). I am using this to experiment with the IFS function ( a new function in...
