Skip to Navigation

Formula Function Reference

Our Formula Function Reference

Mod - Numbers

(Number n, Number m)
Result Type: 
Returns n modulo m. Mod implements 'clock' arithmetic; it models movement around a clock that is labeled with the numbers 0 to m-1. To get the result, just count n times around the clock. (Mod is the same as Rem for positive numbers, but different for negative numbers.) You might use this function to auto-assign tasks to staff members. For details, please read Article #308 in the QuickBase KnowledgeBase
Mod(7,3) returns 1 Mod(-7,3) returns 2 Mod(7,-3) returns -1 Mod(-7,-3) returns -2 Sample auto-assign formula: If (Mod([Record ID#],ToNumber([number_of_reps])) = 0, ToUser("jsmith"), Mod([Record ID#],ToNumber([number_of_reps])) = 1, ToUser("bboop"), Mod([Record ID#],ToNumber([number_of_reps])) = 2, ToUser("ppeabody"))


Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit