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
Aug 01, 2018Diamond Contributor
You may multiply your numbers on 100 and when use ISODD() function
- pyajmalAug 01, 2018Copper Contributorany other option for with out using the IS ODD Function ()
- SergeiBaklanAug 01, 2018Diamond Contributor
ISODD() or ISEVEN() is the easiest way. Alternatively =IF(MOD(A1,2),"ODD","EVEN").
We speak about integers
- pyajmalAug 01, 2018Copper Contributor
Thank you very much