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.