Forum Discussion

Copper Contributor

Mar 25, 2020

formula to calculate notice period

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

excel

Formulas and Functions

Abiola1

MVP

Mar 25, 2020

This is the way your IF formula ought to look like

=IF(AA4<=5,"1Month",AA4*1)

Kayletab

Copper Contributor

Mar 26, 2020

Abiola1

Thank you for simplifying the formula. Do you know how I can limit the answer to a maximum of 12 on the aa4*1?