if then formula for three

[leah]

I have three gas prices of which I'm trying to find the lowest (R,S,T)(in
three different cells). If R is the lowest I want it to return the letter
"C", if S return letter "O", or if T return the letter "Y". I want the
answer to appear in one cell.

 

[Jason Morin]

Assuming "R" gas price in A1, "S" price in B1, and "T" in
C1, try:

=CHOOSE(MATCH(MIN(A1:C1),A1:C1,0),"C","O","Y")

HTH
Jason
Atlanta, GA

 

[leah]

Works great! Thank you!

Assuming "R" gas price in A1, "S" price in B1, and "T" in
C1, try:

=CHOOSE(MATCH(MIN(A1:C1),A1:C1,0),"C","O","Y")

HTH
Jason
Atlanta, GA