I need to have a cell give a name of a person who has the most sales. there
is a column with the names of the people and another with the vales or
totals. I am told I can use the IF and MAX function, but I must use them
several times in the same formula to do this. I can use them separately, but
I don't know how to use them together.