I am unsure of what "move up 1" means in this situation, but there are some
formulas that may help, such as the max and min functions.

I made these using the percentages that you gave in cells B23:E23. the
formulas reference themselves, and they are in cells J30:J35 and cells K30:K34
this may give you a start, and clarification of the problem may bring better
help.

=MAX(B30:E30) =AVERAGE(B30:E30)
=MIN(B30:E30) =MAX(B30:E30)-K30
=MAX(J30:J31)/SUM(J30:J31) =K30-MIN(B30:E30)
=MIN(J30:J31)/SUM(J30:J31) =K31/K30
=(J30-J31)/J30 =K32/K30
=(J30-J31)/J31

The formated results of the above formulas look like this:
84.13% 80.27%
76.12% 3.87%
52.50% 4.14%
47.50% 4.818%
9.519% 5.159%
10.520%

Anyway, I grabbed the maximum and minimum number and compared them with each
other and also compared them with the overall average. The key is in using
MAX() and MIN() instead of greater than and less than. That automatically
gets the problem aisle/cranes and shows you right away if an adjustment even
needs to be made. A lookup function or something like it might allow you to
automatically detect which is the max and min, but it might not be cost
effective (your developement time-wise) with so few aisles.

Hope this helps, more details may be needed if it doesn't help, unless
someone else already understands what you are doing from experience with that
kind of problem.
SongBear

"Candace" wrote:

I need to adjust a machine setting according to a 5% average balance between
4 cranes storing pallets.

If the average of 76.12% is 2.5% above the total average of all cranes, then
adjust down to 1.
If the average of 76.12% is -2.5% less then the average of all cranes, then
adjust up to 1.

Aisle1 Aisle2 Aisle 3 Aisle4 Totals

4,092 4,128 4,128 4,128 16,476 Total #Plts
3,115 3,218 3,473 3,420 13,226 Actual # Plts
76.12% 77.96% 84.13% 82.85% 80.27% Avg % Full

82.28% is 2.50% of 80.27%

78.27% is -2.50% of 80.27%
I have worked on this for 3 days and cant get
the formula set. I'm using Excel VS.2003.