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 ...
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.
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 🙂
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.