Hi I am looking for a formula that if the value of one of 3 cells is the highest, then in the formula cell it will enter a value of 1 2 or x. So I have 3 values, column one =0, column 2 =7 and column 3 =2. So if column one was the highest value I would like the cell with the formula to display the number 1, if column 2 is the highest then display 2 and if column 3 is the highest then display x. I hope I have explained this right. thanks.
Solved by D. Y. in 11 mins