Is there a command to take the arithmetic modulus? (https://en.wikipedia.org/wiki/Modulo_operation)
I realize that I can make my own fairly easily, but was wondering if there is already a built-in function.
Is there a command to take the arithmetic modulus? (https://en.wikipedia.org/wiki/Modulo_operation)
I realize that I can make my own fairly easily, but was wondering if there is already a built-in function.
Hello @Dillon_Solliday,
Yup! It is built-in with “%”
=100 % 3
returns 1
Also, I should note that it will retain the sign of the dividend, so:
=-100 % 3
returns -1
Thanks!
I saw you use % a while back – how did you learn that was built in? I’ve been using Remainder().
Haha - I didn’t even know Remainder() existed! 
I think I just presumed % from Javascript.