Can anyone suggest a way to make Excel find the maximum value of two cells, then, depending on which is larger, give the text contained by another cell in the MAX cell's row? Currently I have:
=(MAX($S$4,$S5))
Which only gives the value of the larger cell, but I want it to give the text in R4 if S4 is larger than S5, and give the text in R5 if S is larger that S4. Is there a way to do this?
I have Microsoft Excel 2007.