Forum Discussion
pyajmal
Aug 01, 2018Copper Contributor
Need a vaidation for the odd and even number
Here I am attached my worksheet
- Aug 01, 2018
You may multiply your numbers on 100 and when use ISODD() function
SergeiBaklan
MVP
You may multiply your numbers on 100 and when use ISODD() function
pyajmal
Aug 01, 2018Copper Contributor
any other option for with out using the IS ODD Function ()
- SergeiBaklanAug 01, 2018MVP
ISODD() or ISEVEN() is the easiest way. Alternatively =IF(MOD(A1,2),"ODD","EVEN").
We speak about integers