Good day!
I keep running into a problem that I need help with. I work for a liquor distributor and am building a spreadsheet to automatically allocates highly sought-after items based on account level criteria. I have a clip of the spreadsheet below.
Here is what I need:
1) Create a formula that allocates the available units for each customer (F1*A4), but stop allocating when the "initial allocation" achieved.
2) All allocations must be a whole number
3) The total allocations can not be larger than the initial allocation in Row 1
When I use =round(F1*A4), the total allocated is less than the initial allocation
When I use =RoundUp(F1*A4,0) the total allocated ends up being 4x larger than the initial allocation.
Any help is much appreciated.
BigPerm79
I keep running into a problem that I need help with. I work for a liquor distributor and am building a spreadsheet to automatically allocates highly sought-after items based on account level criteria. I have a clip of the spreadsheet below.
Here is what I need:
1) Create a formula that allocates the available units for each customer (F1*A4), but stop allocating when the "initial allocation" achieved.
2) All allocations must be a whole number
3) The total allocations can not be larger than the initial allocation in Row 1
When I use =round(F1*A4), the total allocated is less than the initial allocation
When I use =RoundUp(F1*A4,0) the total allocated ends up being 4x larger than the initial allocation.
Any help is much appreciated.
BigPerm79
