How do i update the following formula to add, OR if L6=0, then result is 5:
=IF(L6=4,1,MOD(L6+2,5))
Brew, can you set out more clearly what the possible values in L6 can be and what the corresponding results you want are?Yogi, neither solution met the desired result. The problem is the result can only be 1, 2, 3, 4, or 5, so in L7 increased the result from L6 by adding +2, however if L6=4, then L7=1 or if L6=5, then L7=2