Comparing Numbers

[pomper]

Hi,

I have columns with decimal numbers that I want to compare

Please Login or Register  to view this content.

How can I convert following IF conditions into formula

Please Login or Register  to view this content.

and output results in Column D

[benishiryo]

hi pomper. are they only 2 possible outcomes? if so,
=IF(A2>B2,A2,C2)

if there are other outcomes, i label it as blank. you can adjust as you deem fit
=IF(A2>B2,A2,IF(A2<B2,C2,""))