# Modulus?
**URL:** https://community.glideapps.com/t/modulus/63542
**Category:** Ask for Help
**Created:** [July 5, 2023, 8:20pm UTC](https://community.glideapps.com/t/modulus/63542 "2023-07-05T20:20:08Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@jkirkwood001](https://community.glideapps.com/u/jkirkwood001)
#### Post date: [July 5, 2023, 8:20pm UTC](https://community.glideapps.com/t/modulus/63542/1 "2023-07-05T20:20:08Z")
The AI Help suggests we can calculate the modulus of a number using the % character. But this fails for me.
Help:
…
5. In the “Type” dropdown, select “Other” and then choose “Math”.
6. Give the column a name and click “Done”.
7. In the “Configuration” field of the Math Column, write the formula to calculate the modulus using the “%” operator. For example, if your number column is named “Number”, the formula would be “Number % 5” to calculate the modulus of the number column divided by 5.
Has anyone else calculated modulus? I need this for a Glide table entry form (so Sheets won’t work).
Thanks!
J
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [July 5, 2023, 8:37pm UTC](https://community.glideapps.com/t/modulus/63542/2 "2023-07-05T20:37:05Z")
If you want to divide by 5 then it’s…
Amount/5
Edit: For modulus its’s written like…
Mod(5,7)
---
### Author:  [@jkirkwood001](https://community.glideapps.com/u/jkirkwood001)
#### Post date: [July 5, 2023, 8:43pm UTC](https://community.glideapps.com/t/modulus/63542/3 "2023-07-05T20:43:25Z")
Nope, that was from the AI help.
I want to know if a value is a multiple of 500 ($). I can get around this with some math namely:
AMOUNT column [assume 8250]
SHARES is ROUND(AMOUNT / 500, 0) = 17 (shares $500 each)
SHAREAMOUNT is SHARES \* 500 = 8500
AMOUNT VALID? is IF SHAREAMOUNT = AMOUNT = TRUE, otherwise = FALSE
But a modulus (math) column would be simpler.
---
### Author:  [@jkirkwood001](https://community.glideapps.com/u/jkirkwood001)
#### Post date: [July 5, 2023, 8:45pm UTC](https://community.glideapps.com/t/modulus/63542/4 "2023-07-05T20:45:08Z")
Oh, I didn’t see mention of MOD() function. That works too!
Thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 6, 2023, 12:45am UTC](https://community.glideapps.com/t/modulus/63542/5 "2023-07-06T00:45:18Z")
Please always take the replies from the AI bot with a grain of salt, it can always hallucinate info.
---
### Author:  [@jkirkwood001](https://community.glideapps.com/u/jkirkwood001)
#### Post date: [July 6, 2023, 1:31pm UTC](https://community.glideapps.com/t/modulus/63542/6 "2023-07-06T13:31:05Z")
Understood, thanks. But there was no mention of modulus elsewhere, so that was my fallback! Cool that Glide is testing this out in a practical way. It usually helps me. 🙂
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [July 6, 2023, 1:40pm UTC](https://community.glideapps.com/t/modulus/63542/7 "2023-07-06T13:40:32Z")
Under ‘Functions’
> **[Glide • Math Column](https://www.glideapps.com/docs/reference/computed-columns/math-column)**
>
> Perform instant calculations using the data in your project.
I always check the docs… almost never use the AI
---
### Author:  [@jkirkwood001](https://community.glideapps.com/u/jkirkwood001)
#### Post date: [July 7, 2023, 5:20am UTC](https://community.glideapps.com/t/modulus/63542/8 "2023-07-07T05:20:16Z")
You’re right, Eric, I missed it there. I searched for “modulus” and scanned the functions list but missed MOD.
I understand the AI is imperfect, but it also usually points to the primary reference for its advice, so I can find where in the docs an item is listed.
Thanks!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [July 8, 2023, 5:21am UTC](https://community.glideapps.com/t/modulus/63542/9 "2023-07-08T05:21:14Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.