Holiday Entitlement and Pro-Rata based on Length of Service

Hi Precious

You would need to use the IF function to allow Excel to make the decision to check the entitlement and then include it.

So it could look something like this:-

=IF(Length of Service >= Long Service, Additional Holidays, Nothing)

This would display the additional holiday entitlement or 0

You would then include in the adjacent columns the calculation to workout the value of the additional holiday e.g. Value of Additional Holidays = £ Daily Salary * Additional Holidays

As discussed in the training course, prepare all your calculations prior to commencing creating your spreadsheet as this will give you clear guidance as to what needs to be included.

Feel free to get back in touch when you're closer to creating the calculations.

Regards

Dennis