=MOD(-Input,3)
Although LibreOffice is giving me -0 for an input of 3 so you may need:-
=ABS(MOD(-Input,3))
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.
@SwissChap started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
=MOD(-Input,3)
Although LibreOffice is giving me -0 for an input of 3 so you may need:-
=ABS(MOD(-Input,3))