'Divide an amount between the cells until it runs out
So first I have this difference between these two values on "CORREIOS" worktable:
in the "CORREIOS" if the value of the lines is greater than 0 the formula of the second image will act and distribute the value of the difference following the criteria of the lines, but sometimes it divides and leaves 0.01 cent out, I would like to know how I do to get around this by including that 1 cent somehow
My formula check if those lines are >0 (G5:G15)
My formula in action, but the 1 cent is there, "C3" is the amount of times I must divide which is four in this case
translated formula of the image above:
=IFERROR(ROUND(IF(CORREIOS!G5>0;CORREIOS!$G$18/FORMULAS!$C$3;"");2);"")
I need a formula that divides an amount between cells that of DIFF 2 (H Col) that already have values, I need the division to be until the value in red runs out, example I currently have -0,01 to divide, so it would just throw that value on H3 ( first line of DIFF 2 ), but if it had -0,02 for example it would divide between H3 and H4, another example if I had -0,15 > -0,04 H3 / -0,04 H4 / -0,04 H6 / -0,03 H7, so that the values in green are the same.
You can ignore DIFF 1, it's just a column to pull values from another table.

Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|


