You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
-
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.
aggi-
Glad to help, well, until @Greenbank had the better idea anyway :D
SwissChap
=MOD(-Input,3)
Although LibreOffice is giving me -0 for an input of 3 so you may need:-
=ABS(MOD(-Input,3))