All formulas that begin with =IF will

change the formatting of a cell in a specific way if certain conditions are met.
return a specific value, calculation, or message if certain conditions are met.
always copy the contents of the adjecent cells if they contain data.
remove contents from a cell if they will likely cause an error during calculations.