Excel Nesting IF Function

Ran into an interesting question for a client today. I was asked how to take a set of data from a basic Score Key

Score key: #
very positive 1
positive 0.8
neutral 0.5
unrelated 0.5
negative 0.2
very negative 0

And apply that data automatically to a big list of Excel values such as below and have it automatically populate in the correct number.

very positive
positive
very negative
positive

The answer is to use a nested IF function. I built one as follows:

=IF(c15=”very positive”, 1, IF(c15=”positive”, .8, IF(c15=”neutral”, .5, IF(c15=”unrelated”, .5, IF(c15=”negative”, .2, IF(c15=”very negative”, 0, “ERROR”))))))

Anza-Borrego State Park Pictures

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

image

Pictures of Tara and I’s trip to Anza-Borrego State Park. we also explored the surrounding regions including Lake Henshaw, Salton Sea and Palomar Mountain Preserve.

What Powers AOL Search Results

If you go to Google and search for “What Powers AOL Search Results” you get the following funny suggestion:

American Government Squashing Entrepreneurs

The American government (and governments everywhere) have long been known for it’s large size, opposition to change of any kind and corruptly giving benefits to its supporters.

This trend is going stronger than ever in America. Over a trillion dollars in subsidies are handed out each year to incredibly poorly run organizations like Boeing and old school farming companies and banks.

Not only does the government use trillions of tax dollars paid by hard working entrepreneurs to pay for these benefits, but the American government creates special rules to protect its benefactors (especially the American Medical Association, big banks, poorly run farms, etc).

Ever wonder why the cost of healthcare is so ridiculously expensive in this country? The American Medical Association (the AMA is the most powerful union in history) has pushed through laws to protect its members from competition, making it extraordinarily difficult to provide low cost healthcare. Basically, all entrepreneurs who don’t join the union are shut off the health care industry. This is why you pay so much money in insurance & for simple doctors visits. Do you think if a fresh entrepreneur opened a hospital you would pay $8,000 per day for a room? I very much doubt it.

The other major problem is that the government in California is specially set up to protect big old businesses while keeping out fresh competition. It costs almost $1,000 to just pay government fees to open an LLC and that doesn’t even begin to cover all of the other city & county scammy fees. It’s very hard to pay that much money before your business has made a single red cent.

Adwords Search Advertising Advanced Exam

I just took & passed the Adwords Search Advertising Advanced Exam and passed with a 93%. I got a little cocky after my last exam and didn’t study for this one and was surprised by some Adwords API questions. Also probably didn’t help taking it right before bedtime. Oh well.

President Obama Knows Lots about the NCAA Tourney

President Barack Obama knows a lot about the NCAA tourney…. too bad he doesn’t know or do more about Libya, Bahrain, Japan or the deficit.

Nicely Designed Site

The web designers for Aventura did a really great job on setting up the new ERM site. I like the color scheme, simple layout and video integration. I am a bit confused by some of the copy though.

Love this article

http://www.cnn.com/2011/OPINION/03/11/welch.npr.funding/index.html

I hate that I’m forced to fund professional & college sports stadiums… and I love sports. I hate that I am forced to subsidize agriculture… and I love food. I hate that I’m forced to subsidize NPR… and I love their programs.

Flag Football in Venice Ca

My flag football meetup group is growing and we are getting 8-10 regulars now. We had another good game today and my worker David came out and had a TD catch and an int TD.