Adding an OR condition to the MOD formula

[Brew]

How do I update the following formula to add, or if "0", then the result is also "5"
=MOD(L7+2,5)

 

[erik.van.geit]

Hi,

it would be good to study how to nest functions

check helpfiles for OR
OR(logic1, logic2, ....)

kind regards,
Erik

EDIT: deleted part of message which could be confusing

 

[Brew]

Ive already tried a couple solutions, neither worked
=OR(L7=0,5,MOD(L7+2,5))
=if(L7=1,5,MOD(L7+2,5))
Anybody, have a working solution

 

[erik.van.geit]

in fact when rereading your question, it can be interpreted in different ways
can you tell us in plain english what you are trying to do ?
and provide some examples

 

[Brew]

L7 can only be 1,2,3,4 or 5, so in L8 i want 2 increase the result in L7 by 2,
so the rule is if
L7=1, then L8=3
L7=2, then L8=4
L7=3, then L8=5
L7=4, then L8=1
L7=5, then L8=2

 

[erik.van.geit]

try
MOD(L7+1,5)+1

 

[erik.van.geit]

suddendly I understand what you were trying to do

your second formula was close
just replace "1" by "3"
=IF(L7=3,5,MOD(L7+2,5))

 

[Brew]

Yep, that's it. thanks Erik

 

[erik.van.geit]

you're WELCOME

the last clarification did the trick, you could have put this in your inital question