IF Function and Formulas

Whoa! That was an amazing lesson! but i was really confused with that veeeeeerryyy looooooonnnnngggg Formula to get that Average and Remarks without typing it many times in each cell.

Functions of AND, OR and NOT help to make shortcuts on doing the activity given to us.

In Microsoft Excel, the AND function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.

Example:

Based on the Excel spreadsheet above, the AND function would return the following:

=AND(A1>10, A1<40)	would return TRUE
=AND(A1=30, A2="www.checkyourmath.com")	would return FALSE
=AND(A1>=5, A1<=30, A2="www.techonthenet.com")	would return TRUE

In Microsoft Excel, the NOT function returns the reversed logical value.

Example:

Based on the Excel spreadsheet above, the NOT function would return the following:

=NOT(A2="techonthenet.com")	would return FALSE
=NOT(TRUE)	would return FALSE
=NOT(FALSE)	would return TRUE
=NOT(A1<10)	would return FALSE
=NOT(A2="Microsoft")	would return TRUE
=NOT(5+1=7)	would return TRUE

In Microsoft Excel, the OR function returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE.

Based on the Excel spreadsheet above, the OR function would return the following:

=OR(A1<10, A1=40)	would return FALSE
=OR(A1=30, A2="Microsoft")	would return TRUE
=OR(A1>=5, A1=20, A2="techonthenet.com")	would return TRUE

source: www.techonthenet.com

Ahh.. I took a lot of time to finish that Class Record of Mine (activity). But, with the help of the IF, it makes changes a lot easier than the others. But still, i should find out the formula in getting the STANINE of class records.