Microsoft Excel Functions & Formulas

Use the IF function to check for larger,

equivalent, or smaller values

In the previous example, two different messages were used as the

result for comparing values. To check for three conditions in

column A and present the result as “Column A is larger,” “equal,”

or “Column A is smaller,” perform the following steps.

4

To compare columns and show the result:

1. Copy the previous example.

2. Select cells C2:C12 and type the following formula:

=IF(A2>B2,"Column A is larger",IF(A2=B2,"equal",

"Column A is smaller")).

3. Press <Ctrl+Enter>.

Note: Up to seven IF functions can be combined in one cell.

To combine more than seven functions, use the customized

solution ...