Forum Discussion

S Campbell's avatar
S Campbell
Copper Contributor
Feb 25, 2018

EXCEL Formula

 

If E2 is between 1-11, result is number in E2 plus 1

If E2 equals 12, result is 1

 

Can't seem to write a formula to do this

excel
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Feb 25, 2018

    Hi,

     

    Please try this formula:

    =IF(AND(E2>=1,E2<=11),E2+1,IF(E2=12,1,0))

     

    But if E2 is greater than 12, it will return 0.

    If you want it to returns something else you can replace the 0 in the last of the formula with it.

Resources