9.22.2011

Excel Strikes Again


I got to admit I'm getting a little off edge with these tables, so since I already have a former post of an excel table I won't get into much detail. I used the formula:

=IF(MIN(B4:D4)<5, "failed", AVERAGE(B4:D4))
Things are simple if you want to calculate the interpose of someone use the formula, the only thing that's changed is that rather then saying "passed" "failed" it shows you the interpose, and if the student failed then it obviously shows "failed". There is really no need to get into much details, just use that formula, change the data if needed, and look at the image above, it's really simple.

9.19.2011

Return Of Excel


As my title suggests, The Beaver is back with a new Excel mini lesson again. These time I had to make a table. Here are the formulas that I used:

=average(b2,b3,b4,b5)
=average(c2,c3,c4,c5)
=average(d2,d3,d4,d5)
=average(e2,e3,e4,e5)
to calculate the interpose I used the same formula only with changed data:
=average(b6,c6,d6,e6)
in order to calculate if the student passed or failed use:
F5-> =IF(AVERAGE(B5,E5)<5, "failed", "passed").
That's all for today. Look at the image above.

9.12.2011

Memories From Hell

As my eye catching title suggests I didn't quite had a good summer break. Most of time I stood indoors, watching movies, playing the guitar, these summer for me wasn't about relaxation it mostly was about finding my self, and of course because I wasted so much time in the house meditating like some persons I had an epiphany, or as alcoholics may refer to it a moment of clarity. One thing that I wont forget and I'm gouging my eyes for is missing the Bon Jovi concert in July, because i had bronchitis and that's my biggest regret. In conclusion these summer wasn't as good as the one before it. One more thing the title refers to the nasty memory that I had when Oradea was struck by a heat wave, and I felt like I was in Hell.