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

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

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.

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

Happy to help

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1