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
Glide vs. GSheets Optimization Poll Ask for Help	0	261	January 16, 2021
What are all formula you can use with math? Ask for Help	8	3135	July 6, 2021
If-this-and-that-then Ask for Help	10	661	December 12, 2019
Math operations conditions Feature Requests	2	298	September 1, 2020
Can't calculate sum of if/then/else values Report a Bug	1	354	February 7, 2024

Is there an IF ODD in Glide Sheets

Related topics