Forum Discussion

Kayletab's avatar
Kayletab
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's avatar
Abiola1
MVP
Mar 25, 2020
This is the way your IF formula ought to look like

=IF(AA4<=5,"1Month",AA4*1)
Kayletab's avatar
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?

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 26, 2020

    Kayletab 

    Perhaps

    =IF(AA4<=5,"1Month",MIN(12,AA4*1)))
    • Kayletab's avatar
      Kayletab
      Copper Contributor
      Mar 26, 2020

      Yes that worked perfectly thank you SergeiBaklan 

Resources