PDA

View Full Version : Excel Question

MannyL
07-17-2009, 09:19 AM
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
07-17-2009, 09:45 AM
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
07-17-2009, 09:53 AM
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
07-17-2009, 10:19 AM
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