Thanks Colin for your time.

Well, lets say you have the following:

Column A | Column B | Column C
1.25 5 5
1.5 6 6
1.75 7 7
2 8 2
2.25 9 9


I would like Excel to compare the number in Column A with the number in Column B and decide which number does NOT have a decimal and put that result in Column C. If both numbers are whole numbers, then put the smaller number in Column C.

For example, in row 1, Column C should display 5 because it is not a decimal. For row 2, Column C should display a 6 because it is not a decimal. In row 4, Column C should display a 2. Since both numbers are whole numbers, the smaller number would be the correct number.

HTH's.



Rey