Logic Statement
Knowing that an even number added to an even number results in an even number, an odd number added to an odd number results in an even number, and that an odd number added to an even number results in an odd number, how would i write a logic statement that will predict if the sum of any two integers is even or odd? The algorithm doesn't need to test for the actual sum, but just show if the sum of the two numbers will be an even or an odd number.
like this??
=IF(SUM(A1:B1)/2=INT(SUM(A1:B1)/2),"even","odd")
A1 and B1 are the numbers to be added..
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi jeanmuhree,
See the attachment. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Yes this worked! thank you!
Thanks for the rep.
look at also dilipandey sample for another approach ( -- used function mod() )
If your problem is solved, please say so clearly, and mark your thread as Solved:
Click the Edit button on your first post in the thread,
Click Go Advanced,
select [SOLVED] from the Prefix dropdown.
Thanks vlady.. for considering / reviewing my solution as well.
Cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks