Each IF function in an Excel spreadsheet returns one of two messages. The first -- the "if" message -- displays if cells meet criteria that you specify. The second -- the "otherwise" message -- ...

If-Then rules allow you to create colorful business spreadsheets that do more than look pretty. Meaningful colors can help you and others identify data quickly, recognize trends and even spot ...

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 against ...

Nested IF statements used to be my go-to whenever I needed to juggle multiple conditions in Excel. However, just because they get the job done doesn’t mean they’re the best tool for the job. Wrestling ...

is any macro expression that resolves to an integer. If the expression resolves to an integer other than zero, the expression is true and the %THEN clause is processed. If the expression resolves to ...

In our new series Getting It, we’ll give you all you need to know to get started with and excel at a wide range of technology, both on and offline. Here, we’re arming you with everything you need to ...

The IF expression is evaluated first. If the expression is true, execution flows through the THEN alternative. If the expression is false, the ELSE statement, if present, is executed. Otherwise, the ...