I'm close ... Comparing values and returning a conditional response
Posted by Chuck on March 20, 2001 10:14 AM
Hi. First time poster, and I'm a bit nervous, but what a wonderful resource!
I'm trying to compare a group of 8 numbers, from g3..n3 (and g4..n4, and so on) and then print out a phrase depending on which column has the highest number.
If two of the numbers between g3..n3 are the same, and they are the two highest numbers, I would like to print the word "TIE"
I came close, I think, as you will see if you follow the link, but if the two highest numbers are the same, it doesn't print "TIE"
I would appreciate any advice.