Forum Discussion
Solved
Need a vaidation for the odd and even number
Here I am attached my worksheet
You may multiply your numbers on 100 and when use ISODD() function
4 Replies
You may multiply your numbers on 100 and when use ISODD() function
- any other option for with out using the IS ODD Function ()
ISODD() or ISEVEN() is the easiest way. Alternatively =IF(MOD(A1,2),"ODD","EVEN").
We speak about integers
Thank you very much
