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