Polaroid Photo

Thu
28
Dec '06

Sometimes it’s better not to know.

I’ve had three different people ask me how my day was, to which I answered “fine.” They then pressed for details expecting, no doubt, me to regail them with tales of puppets gone bad. Alas. I’m working on a spreadsheet, which I explained. Two of the people did not believe me when I explained that it is deathly boring.

For those unbelievers, here is one of the formulas that I’m writing.

IF(AND(B2< =5;OR(C3<=5;C3=11;C2=1);OR(B3<=5;B3=11));"in January - May, and November";IF(AND(B2<6;B3>5;B3<11;OR(C2=1;AND(C3>5;C3<11)));”in June-October”;IF(AND(B3=12;OR(C3=12;C2=1));”in December”;IF(AND(B2=6;OR(C3=5;C3=10;C2=1);OR(B3=5;B3=10));”in May and October”;IF(AND(B2>6;B2<9;B3>4;B3<11);”in May - October”;IF(OR(B2=9;B2=10);”year round.”;IF(AND(OR(AND(Formulas.C3>5;Formulas.C3<10);C2=1);AND(B3>5;B3<10));”in June-September”;”THE MONTH FIELD DOES NOT MATCH THE DATE ENTERED”)))))))