Forum Discussion
Help to create a formula
Hi I am trying to create a formula that tells me that I need to change the rate of pay for someone when they reach a new age category. I have a column and formula to create the exact age (17years, 3 ...
SergeiBaklan Hi Sergei thank you for the response I have attached a sample of my file 🙂
I will populate columns A to J each month
Stella1000 , thank you for the file. Could you please clarify - you have conditions
- Apprentices over>19 and <1 years service
- Apprentices<19
What shall be taken if Apprentices=19?
What shall be taken if Apprentices over>19 and >= 1 years service (or you fire such)?
Stella1000 , great to know it works as expected, thank you for the feedback.
- I have been able to check the calculation now and it has worked!!!!
THANK YOU!!!! Stella1000 , you are welcome. Please post if any questions.
- Thank you so much, I haven't got time at the moment to check, but will do as soon as I can, once again thank you, I really appreciate your help 🙂
That could be
=IF( AND( $J2 = "Yes", OR( $K2 < 19, AND( $K2 >= 19, $N2 < 1) ) ), 5.28, LOOKUP( $K2,{0,18,21,23},{5.28,7.49,10.18,10.42} ) )Please check attached.
- Hi Sergei apprentices equal to and over 19 need to have the NMW for their age,
NMW rate
National Living Wage (23+) £10.42
21-22 Year Old Rate £10.18
18-20 Year Old Rate £7.49
16-17 Year Old Rate £5.28
Apprentice Rate £5.28
Apprentices aged 19 and over, but in the first year of their apprenticeship £5.28
thank you