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.

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:

2 Likes

How to call the roll?

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

Is there an IF ODD in Glide Sheets

Related topics