if then formula for three
 

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.

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

-----Original Message-----
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.
.

Works great! Thank you!

"Jason Morin" wrote:

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

-----Original Message-----
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.
.