Microsoft excel few tips

Logical test code:
if statement

=if(logical_test,[value_if_true],[value_if_false]

example:

=IF[L7=M7,("T"),("F"))
OR =IF[L7=M7,"T")




Conditional formating:

COUNTIF Syntax

=countif(range,criteria)

=COUNTIF(A1:A20,">20")




=Propper(A1)
=Upper(A1)
=Lower(A1)