I need to compare corresponding cells of two

columns in excel and display the smaller of the

two values in the corresponding cell of a third

column.Any help would be appreciated. Thanks.

Hi, with your two values in A1 and B1, put this formula in C1:

=IF(A1<B1,A1,B1)

Drag the formula down column C as far as there are values to be compared in columns A and B.

You didn't say if you wanted anything different if the values in A and B were the same. If you do, please respond with further information.

Regards

PS as the IF() statement is such a basic building block for formulas in Excel, I suggest you read the help file, so that you understand how it works, and how IF() statements can be nested.

Hello, I have been scanning the web trying to find a formula that can calculate the difference between 2 columns placing that number in a row below with conditional formatting showing red increase, yellow same, and blue decrease. Below is the actual numbers: dates followed by data below, and then the sum, with the difference between the rows (manually completed) If you would be so kind to assist, I'd be much appreciative - thank you for your time. 10/10/10 10/11/10 10/12/10 10/13/10 10/14/10 10/15/10

366 375 375 377 378

257 257 257 253 253

55 55 55 56 56

32 32 32 30 30

5 5 5 5 5

28 28 28 28 28

4 4 4 4 4

336 338 337 338 337

198 198 198 194 191

400 400 400 391 391

14 13 13 13 13

1695 1705 1704 1689 1686

10 -1 -15 -3

Ask Your Question

Weekly Poll