Next if(and statement

[Groovicles]

Hi guys,

Here's what I'm trying to do:

If A1>B1 and A1>C1, then D1="High"
If B1>A1 and B1>C1, then D1="Medium"
If C1>A1 and C1>B1, then D1="Low"

Can't seem to figure this one out. Any suggestions?

Thanks!!

[AliGW]

I think this will work pasted into D1:
=IF(A1=LARGE(A1:C1,1),"High",IF(B1=LARGE(A1:C1,1),"Medium","Low"))

[AlKey]

Or this

=IF(AND(A1>B1,A1>C1),"High",IF(AND(B1>A1,B1>C1),"Medium",IF(AND(C1>A1,C1>B1),"Low","")))

or

=IF(A1=MAX(A1:C1),"High",IF(B1=MAX(A1:C1),"Medium","Low"))

[Groovicles]

Thanks very much AlKey!

[AlKey]

You're welcome and thank you for your feedback!

[AliGW]

Not Alkey, but thank you for the reputation points.