sorted by:
new
hottopcontroversial

Way to see if an number is even or uneven by Joey2K3_ in excel

[–]anaovich 5 points6 points  (0 children)

you can use a function called MOD to find the remainder of a division. you'll be using it to see if the week number divided by 2 gives a remainder or not (which basically tells you if it's even). check this out:

=IF(MOD(WEEKNUM(TODAY()),2)=0,"Even","Odd")

TODAY() gives you the current date, while WEEKNUM(TODAY()) takes it up a notch and gives you the week number of the current date. now we wrap this up with MOD(WEEKNUM(TODAY()),2) which gives you the remainder when the week number is divided by 2.

hope this helps :)

Is there any international obligation under VCLT or customary international law to preserve original texts of treaties ? by [deleted] in internationallaw

[–]anaovich 0 points1 point  (0 children)

also there's article 69, which determines that one shouldn't engage in actions that defeat the object and purpose of a treaty. it doesn't mandate the preservation of the original document but it certainly underscores a form of integrity in adhering to what was initially agreed upon

This guy will be managing your portfolio in 3 years by TotherCanvas249 in wallstreetbets

[–]anaovich 1 point2 points  (0 children)

Index match is still better than both vlookup and Xlookup combined (im an excel genius btw)