An IF statement returns a value based on a TRUE/FALSE evaluation, and you can nest IF statements inside another to create complex logic. ... The SWITCH statement in Excel is a relatively new function.

You can create your own investment statements with a template from the Microsoft Office website. These free templates include a "Statements" category with predesigned forms for the Excel program ...