formula to calculate notice period

Question

Hi,&nbsp;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&nbsp;=IF((AND(AA4&lt;=5)),"1Month",AA4*1)&nbsp;Thanks

abiola1 · Answer

This is the way your IF formula ought to look like=IF(AA4&lt;=5,"1Month",AA4*1)

sergeibaklan · Answer

Kayletab&nbsp;
Perhaps
=IF(AA4&lt;=5,"1Month",MIN(12,AA4*1)))

kayletab · Answer

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

kayletab · Answer

Yes that worked perfectly thank you&nbsp;SergeiBaklan&nbsp;

sergeibaklan · Answer

Kayletab&nbsp;, glad to help

Forum Discussion

formula to calculate notice period

7 Replies

Resources