Microsoft Excel Functions & Formulas

Use the IF function to compare columns and

return a specific result

As shown in earlier examples, Excel returns the value TRUE or

FALSE when using the OR and AND functions. The IF function can

also be used to conduct conditional tests on values and formulas.

This example compares two columns and shows the result in

column C.

4

To return specific text after comparing values:

1. Enter in range A2:A12 values from 1 to 1000.

2. Enter in range B2:B12 values from 1 to 1000.

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

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

B is greater").

4. Press <Ctrl+Enter>.

44

Chapter 2

Figure 2-5