Mar 25 2020 03:23 PM
Hi,
I am currently using the following formula to calculate notice period but the maximum years is 12 how can i add a clause to the formula to ensure the number calculated is no more than 12
=IF((AND(AA4<=5)),"1Month",AA4*1)
Thanks
Mar 25 2020 04:23 PM
Mar 26 2020 12:47 AM
Thank you for simplifying the formula. Do you know how I can limit the answer to a maximum of 12 on the aa4*1?
Mar 26 2020 01:18 PM
Mar 26 2020 01:21 PM
Yes that worked perfectly thank you @Sergei Baklan
Sep 18 2020 03:48 AM
Sep 18 2020 11:22 AM