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