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.

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.

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!

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 Using @Jeff_Hager 's floor method of checking if a number is even or odd: [image] The LIKE Count is how many times…

[image] 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 hav…

You could also use mod(COLUMN,2). The result will be 0 (even) or 1(odd)

[image] Robert_Petitto: even This is great. thank you both

yah, I often use MOD() in combination with a column that’s used as a toggle switch

Is there an IF ODD in Glide Sheets

Ask for Help

Robert_Petitto January 29, 2021, 3:50am 9

It works wonder in my attendance taking app:

How to call the roll?

Topic		Replies	Views
Count check-list Ask for Help	16	427	October 28, 2022
Count if excel formula Ask for Help	3	567	May 3, 2023
What are all formula you can use with math? Ask for Help	8	3224	July 6, 2021
Inputted Goggle Formula not working? Ask for Help	19	287	April 18, 2023
Glide vs. GSheets Optimization Poll Ask for Help	0	263	January 16, 2021

Is there an IF ODD in Glide Sheets

Related topics