Excel Functions

Objective: This article gives some day to day usage of excel functions.

The below excel function will return the output in other column based on the requested excel column. In this case, A1, A2 are the requested column information as mentioned below.

=If(A1>10, "Larger", "Smaller")	would return "Larger".
=If(A1=20, "Equal", "Not Equal")	would return "Not Equal".
=If(A2="Tech on the Net", 12, 0)	would return 12.

Reference: http://www.techonthenet.com/excel/formulas/if.php