Excel Question

[MannyL]

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

[Duke]

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)

[Spud]

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%.

[MannyL]

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)

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


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 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