=IF(MAX(A1,B1,C1)=A1,"Charlie is leading",IF(MAX(A1,B1,C1)=B1,"Scott is
leading","Jason is leading"))

"racmb1975" wrote in message
...
Is there a way of writing an IF function to test the values in 3 cells and
return a message depending on which cell has the highest value?
For example if A1 = 1000, B1 = 1500, C1 = 1750. If A1 is has the largest
value then I would like a return of "Charlie is leading", if B1 is higher
then return "Scott is leading" and if C1 is highest then return "Jason is
leading" .....is it possible to write this function?