Thursday, February 02, 2006
We are learning how to compute GPA...
Click on the cell which the formula you want to have will appear... now it in microsoft excel
=IF(C9=4,"excellent",IF(C9=3.5,"superior",IF(C9=3,"very good",IF(C9=2.5, "good",IF(C9=2,"satisfactory",IF(C9=1.5,"fair",IF(C9=1,"passed","failed")))))))
"C" would be the columns...followed by the grade and bla bla bla
that will be for the description column where the word would appear as "excellent" "superior"etc
then ctrl c and ctrl v follows... ooooh... i hate these programming stuff
now we caluculated the honor points...
=b8*c9...and tada
and there's auto sum and it look like a greek E... at the top bar...
we found the minimum grade by =MIN(C9:C15)
=if(and(c17>=2.0,B18>=3.400),"first honor",if(and(c17>=2.0,B18>=3.000),"second honor","next time na lang"))
to determin whether the first person is a first, second honor. personally i hate to be an honor awardee because it raises competition. do you know that girls have a higher sense of competition? everybody says so... and i know some people who are doing that to me... im just not saying out who(s)... bwahaha... i wanna take a rest this term... just to get out from it all... im really tired studying like maniac... serious... just let those get DL this term and let me be in peace... pretty please...???
oh there's a shortcout (-_-") just click the goddamned insert>function... blabla... there lot of choices...