# Is there an IF ODD in Glide Sheets
**URL:** https://community.glideapps.com/t/is-there-an-if-odd-in-glide-sheets/21900
**Category:** Ask for Help
**Created:** [January 28, 2021, 8:23pm UTC](https://community.glideapps.com/t/is-there-an-if-odd-in-glide-sheets/21900 "2021-01-28T20:23:15Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@spencersRus](https://community.glideapps.com/u/spencersRus)
#### Post date: [January 28, 2021, 8:23pm UTC](https://community.glideapps.com/t/is-there-an-if-odd-in-glide-sheets/21900/1 "2021-01-28T20:23:15Z")
I am aware of a google sheets formula that will determine if a number is ODD.
But is there a way in the Glide Sheets? Somehow using the Math or the If:Then?
I am trying something out, but the lag is too long going back to the sheet.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 28, 2021, 8:33pm UTC](https://community.glideapps.com/t/is-there-an-if-odd-in-glide-sheets/21900/2 "2021-01-28T20:33:42Z")
Use a math column to divide the number by 2, floor it, then multiply by 2.
`FLOOR(N/2)*2`
Then create an IF to compare the original number column to the new math column. If the numbers match, it’s EVEN. If they don’t match, it’s ODD.
---
### Author:  [@ehdubya](https://community.glideapps.com/u/ehdubya)
#### Post date: [January 28, 2021, 8:37pm UTC](https://community.glideapps.com/t/is-there-an-if-odd-in-glide-sheets/21900/3 "2021-01-28T20:37:02Z")
Jeff…is there a way to just auto-bookmark all of your replies? I swear I learn something new from you every day! This is genius!
---
### Author:  [@spencersRus](https://community.glideapps.com/u/spencersRus)
#### Post date: [January 28, 2021, 9:19pm UTC](https://community.glideapps.com/t/is-there-an-if-odd-in-glide-sheets/21900/4 "2021-01-28T21:19:57Z")
Thanks, Here is what I am thinking and it works for me.
Built this concept app just for showing that I am doing.
Try it out.
> **[Likes Floor Method](https://fast-battle-8339.glideapp.io/)**
Using @Jeff_Hager 's floor method of checking if a number is even or odd:
The _LIKE Count_ is how many times the image has been clicked.
The _FLOOR_ is a Math column described that returns a number.
Then the _IF:Odd_ column checks if there is a match.
If it DOES **NOT** match the Like Counter is **ODD** , which means the image was clicked an ODD number of times. Which means the user wants to LIKE it (starting with 1)
If it **DOES** match, the Like Counter is **EVEN** , which means the image was clicked an EVEN number of times, Which means the user does not want to like it. (starting with 2, or not clicking at all)
---
### Author:  [@spencersRus](https://community.glideapps.com/u/spencersRus)
#### Post date: [January 28, 2021, 9:22pm UTC](https://community.glideapps.com/t/is-there-an-if-odd-in-glide-sheets/21900/5 "2021-01-28T21:22:35Z")
> [@Jeff\_Hager](#):
>
> Then create an IF to compare the original number column to the new math column. If the numbers match, it’s EVEN. If they don’t match, it’s ODD.
THIS is GENIUS!
I really did not think there was a way (never heard of the floor method) - but decided to ask anyway.
**Now I have learned something and had fun!**
(Don’t you love when your kids say the above phrases @Robert_Petitto ?)
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [January 28, 2021, 9:41pm UTC](https://community.glideapps.com/t/is-there-an-if-odd-in-glide-sheets/21900/6 "2021-01-28T21:41:07Z")
You could also use mod(COLUMN,2). The result will be 0 (even) or 1(odd)
---
### Author:  [@Nadir\_Abdelrahman\_MD](https://community.glideapps.com/u/Nadir_Abdelrahman_MD)
#### Post date: [January 28, 2021, 10:04pm UTC](https://community.glideapps.com/t/is-there-an-if-odd-in-glide-sheets/21900/7 "2021-01-28T22:04:54Z")
> [@Robert\_Petitto](#):
>
> even
This is great. thank you both
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 29, 2021, 3:33am UTC](https://community.glideapps.com/t/is-there-an-if-odd-in-glide-sheets/21900/8 "2021-01-29T03:33:51Z")
yah, I often use MOD() in combination with a column that’s used as a toggle switch
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [January 29, 2021, 3:50am UTC](https://community.glideapps.com/t/is-there-an-if-odd-in-glide-sheets/21900/9 "2021-01-29T03:50:15Z")
It works wonder in my attendance taking app:
---
### Author:  [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/is-there-an-if-odd-in-glide-sheets/21900/10 "2024-01-17T16:53:40Z")