Forum Discussion
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
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.
Thank you!