Hi there
Have a spreadsheet whereby I need to calculate Pension on a salary, based on the source data meeting certain criteria.
Spreadsheet attached. Worksheet name 'Staff Costs', source data 'Staff Data'.
http://www.excelforum.com/attachment...1&d=1459353891
Cell V16
I've attempted to right a formula but it's not pulling in the desired value.
What I would like:
From 'Staff Data', I would like the formula to check:
Employee cell T13 (Staff Costs), from column G (Staff Data)
ABC cell T5 (Staff Costs), from column B (Staff Data)
Check the employee has started via Staff Data column M (as we're looking at Jan-16) is equal to 1
Start Date cell V5 (Staff Costs), from column I (Staff Data) - then add on 3 months which is when Pension cost becomes effective, assuming it's post Jan-16
THEN,
I would like the formula to return the sum of 'Salary x Pension %'
Hope this makes sense
Help if you can. I've spent a while on it with no luck
Thanks, Maddy
Bookmarks