I've gotten over $200 in cash back from them at places I would have shopped anyway! Ebay, Staples, more! I put it at the top because they ROCK. Basically, you get a kickback from Ebates when buy.com or whoever pays them. Win-win. If you like throwing money away, don't use them!

Wednesday, September 12, 2007

Your Daily Piece of Excel Code


What I did for my Summer Camp (Air Force Reserve annual tour) today: wrote Excel code of course!

=IF(ISBLANK(H6),NA(),DATE(YEAR(H6)+1,MONTH(H6),DAY(H6)+1))

If H6 is blank, then put #NA in this cell otherwise add 1 yr, and one
day to H6 and put it here.

Today's likely capper:

=IF(ISBLANK(Test!I6),NA(),IF(TODAY()>Test!I6,"No",IF(TODAY()>Test!I6-90,
"<90d","Yes")))

If it's blank print NA, otherwise run that nested IF statement and say someone's current, has less than 90 days currency remining, or is noncurrent.

It was kind of fun.

(Sick, isn't it?)

No comments:

 
Google Find us on Google+ Website: www.circlephone.com