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