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
