I want to write a formula that compares three numbers. My cells are M2, X2, and AI2. My output cell is AJ2. So, if M2 is greater than X2 and AI2, then the output cell should read "Visual"; if X2 is greater than M2 and AI2, the output cell should read "Auditory"; if AI2 is greater than M2 and X2, the output cell should read "Tactile/Kinesthetic." I cannot for the life of me get this to work with IF, OR, AND, or a combo of those. Basically, this is a learning style survey for students. I have 600 students to survey, and I need fast data interpretation.
Any help would be greatly appreciated!
Bookmarks