I need to figure out how to do the follwing.
I) Figure out which field of 4 is the highest. which I know LARGE will do that but then I need to see if the other fields in aggreate are equal to or greater 20% of the highest field. As
I’m not sure what the rest of your question is there, but in order to identify the highest of any range of fields, you’d use the MAX() function, i.e.:
=max(a1:a4)
Looks like he wanted to check to see if the other 3 were greater or less than 20 percent of the max cell, so you could put your max function that Duke showed you in a cell… say B1 and then take Sum(a1:a4)-B1 and then compare that to the value in B1 to see if it was greater or less than 20%.
That’s not quite what I’m looking for lets use fruit as an example
If B1 through B4 had
Apples Pears Peaches Plums
And Peaches had the highest number I would want it to say Peaches
That should be perfect. I was trying to figure out how to do the math without knowing which cell was the largest but I can subtract it with LARGEST