I have a table with four columns of integer values. In the fifth column I'd like to have it print a specific string based on which column has the highest value in each row, or a different string if no column has the highest value (i.e. two columns have the same value). Is there a way to craft an IF statement to say:
-If A1 is the highest value in the range of A1–D1 print "A"
-If B1 is the highest in the range print "B"
-If C1 is the highest in the range print "C"
-If D1 is the highest in the range print "D"
-If more than one column has the highest value print "None"
I'm getting lost in nested if-else statements trying to accomplish this and feel like there must be a more straightforward way of doing it than I am attempting.
Bookmarks