I want to apply an excel formula who tell me the "ODD" or "EVEN" number after 2 place of decimal of a numeric figure.
For an example:-
520.73 ODD
540521.76 EVEN
0.17 ODD
14.59 ODD
28569.50 EVEN
Definition of odd is "divide by 2 exactly and no remainder plus.
Please suggest any excel formula.
This works
=LOOKUP(MOD(A1*100,2)+1,{1,2},{"EVEN","ODD"})
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
=IF(MOD(A1*100,2),"ODD","EVEN")
Try this
Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
or
=IF(MOD(ROUND(A1,2)*100,2),"ODD","EVEN")Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks