Compare Tow columns, return the greater value

[beadgirlsa]

Hello,

I'd like to compare Column I with Column J, and in Column K, return the value of the greater column.

For example, in Column I, there are dollar amounts, and in Column J, there are also dollar amounts. I'd like Column K to show the greater of the two dollar amounts.

The only catch is, if Column I has a dollar value, there won't be any dollar value shown in Column J, Column J would be zero (and the same going the other way. If J was a dollar amount, then "I" will not.

Thanks in advance for any help you may have to offer.

 

[Leith Ross]

Hello beadgirlsa,

You can use the Large function to return the highest dollar amount in the 2 columns.

Cell K1 Formula: =LARGE("I1:J100", 1)

Sincerely,
Leith Ross

 

[beadgirlsa]

Just solved it, using IF AND

=IF(AND(PromantekNET>RenewalLicTOTAL),PromantekNET,RenewalLicTOTAL)

the words are named ranges.

Just getting used to syntax around here!

 

[beadgirlsa]

Thank you! I'm going to try your way, too. Might end up working better than mine! Thanks, Leith.