Hi everyone!
I need your help or an idea how to find out a smooth way to calculate it the following problem.
I have a range of data range of 5 cells (B3,C1,D1,E1,F1) and a cell with a adjustment value (G1) that I have to distribute on the data range in the following way:
- If a cell from a data range is 0, will remain 0.
- if a cell has a negative value from a data range than i will draw of from the adjustment value (G1) until is 0
- If after this this procedure will remain a positive value in (G1) that will be distribute on the cells with positive value from the range, distributed according to the percentage value of positive values
- if all cells from the data range will be 0 and in (G1) still we have a positive value than the remained value will be added to A1.
- if F1=0 and in the data range stil we have a negative value then we will draw of from the positive values in the data range.
I hope that it's understandable
Atached I send an exemple.
Bookmarks