You are reading a single comment by @Greenbank and its replies.
Click here to read the full conversation.
-
=MOD(-Input,3)
Although LibreOffice is giving me -0 for an input of 3 so you may need:-
=ABS(MOD(-Input,3))
Greenbank-
Ah there we are! I thought something like that should work, but for some reason my mind went in the direction of shifting the input instead of taking it as a negative number.
-
Cheers and @SwissChap
I'd found a few solutions giving me 2, 1, 3 but none with 2, 1, 0 and particularly none so simple.
SwissChap
aggi
However, I do have the feeling there's an easier solution I'm overlooking.