multiple if

[vapana]

Hi, i have 4 numbers in 4 cells and i want to compare the numbers to find the largest. If the first number is greater, give 1, if the second number is greater , give 2, if the third number is greater, give 3. otherwise give 4. Would you please let me know how i can do this in Excel. Thank you kindly.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=MATCH(MAX(A2:A5),A2:A5,0)

 

[vapana]

Hi, i have 4 numbers in 4 cells and i want to compare the numbers to find the largest. If the first number is greater, give 1, if the second number is greater , give 2, if the third number is greater, give 3. otherwise give 4. Would you please let me know how i can do this in Excel. Thank you kindly.

 

[Fluff]

In that case use

=MATCH(MAX(C5:F5),C5:F5,0)

 

[vapana]

hi, i tried the formula you provided. it works great. but i got a new twist in what i want. please see below. Thank you so much.

 

[Fluff]

Why 3 & not 1?

 

[vapana]

catagory 3 has a higher value that catagory 1, even though cell c5=E5.

 

[Fluff]

How about

=XMATCH(MAX(C5:F5),C5:F5,0,-1)

 

[vapana]

How about

=XMATCH(MAX(C5:F5),C5:F5,0,-1)

How about

=XMATCH(MAX(C5:F5),C5:F5,0,-1)

Thank you so much, you are truly generous and amazing. God bless.

 

[Fluff]

You're welcome & thanks for the feedback.