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
Is numeric column - how to? Ask for Help	13	692	February 7, 2022
What are all formula you can use with math? Ask for Help	8	3057	July 6, 2021
"OR" in a row Ask for Help	7	367	March 23, 2021
Different between 2 dates using Math and Day Ask for Help	5	666	August 31, 2022
Question(I am Beginner) Ask for Help	4	307	January 17, 2024

Is there an IF ODD in Glide Sheets

Related topics