# Allocate certain number dependent on average & percentage

1. ## Allocate certain number dependent on average & percentage

As per the attached.
Column b are names:
Column d are the total amount of listings the person has
Column f is the calculated total amount of listings that person can advertise.

At the top in Cell G2 is the total amount of allocations allowed which is to be divided equally over all the persons listings The more listings the more allocations. However, the formula I currently have doesn't equal the exact amount in Cell G2. It needs to. This is where my problem is.

Currently my formula in column d is: =IF(ROUND(\$D6/\$D\$24*\$G\$2,0)=0,1,ROUND(\$D6/\$D\$24*\$G\$2,0))

This is rounding close but it needs to be exactly what is in cell G2. (remembering that all these numbers can change - including G2)  Register To Reply

2. ## Re: Allocate certain number dependent on average & percentage

This gets you closer, but I doubt you will ever get exact, unless by luck...
=IF(D6=0,0,IF(ROUND(\$D6/\$D\$24*\$G\$2,0)=0,1,ROUND(\$D6/\$D\$24*\$G\$2,0)))  Register To Reply

3. ## Re: Allocate certain number dependent on average & percentage

awesome, many thanks. Real close now. Definitely as close as I will ever get. Thanks again.   Register To Reply

4. ## Re: Allocate certain number dependent on average & percentage

Happy to help  Register To Reply