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.