If you can decide what to have for lunch, you already understand Excel's IF logic--you just need to understand the format.

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.

An IF statement returns a value based on a TRUE/FALSE evaluation, and you can nest IF statements inside another to create complex logic. A SWITCH statement evaluates an expression and tests it ...