hi
I have some minus values in column BALANCE (H) what I want adding the minus value by changing into plus for column BUYING(F) ,then it will become zero in column BALANCE (H)
the result see the column BUYING(F) how add the mius value from column BALANCE(H) after change into puls and how become zero in column BALANCE(H)
as you see the highlighted cells how changes . for instance in row 2 . -2 in column H should be 2 when add to column F , then =2+25=27 and the column H become 0and so on for any minus values should calculate with this way .
I have some minus values in column BALANCE (H) what I want adding the minus value by changing into plus for column BUYING(F) ,then it will become zero in column BALANCE (H)
COLOR2.xlsm | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | ITEM | SSTR | TTR | MMR | NNR | BUYING | SELLING | BALANCE | |||
2 | 8/7/2021 | SLFR-100 | FOOD-1 | PR100 | NRIT1 | 25.00 | 27.00 | -2.00 | |||
3 | 8/8/2021 | SLFR-101 | FOOD-2 | PR101 | NRIT2 | 30.00 | 20.00 | 10.00 | |||
4 | 8/9/2021 | SLFR-102 | FOOD-3 | PR102 | NRIT3 | 35.00 | 23.00 | 12.00 | |||
5 | 8/10/2021 | SLFR-103 | FOOD-4 | PR103 | NRIT4 | 30.00 | 25.00 | 5.00 | |||
6 | 8/11/2021 | SLFR-104 | FOOD-5 | PR104 | NRIT5 | 40.00 | 35.00 | 5.00 | |||
7 | 8/12/2021 | SLFR-105 | FOOD-6 | PR105 | NRIT6 | 45.00 | 10.00 | 35.00 | |||
8 | 8/13/2021 | SLFR-106 | FOOD-7 | PR106 | NRIT7 | 45.00 | 20.00 | 25.00 | |||
9 | 8/14/2021 | SLFR-107 | FOOD-8 | PR107 | NRIT8 | 55.00 | 65.00 | -10.00 | |||
10 | 8/15/2021 | SLFR-108 | FOOD-9 | PR108 | NRIT9 | 60.00 | 5.00 | 55.00 | |||
11 | 8/16/2021 | SLFR-109 | FOOD-10 | PR109 | NRIT10 | 70.00 | 10.00 | 60.00 | |||
12 | 8/17/2021 | SLFR-110 | FOOD-11 | PR110 | NRIT11 | 80.00 | 20.00 | 60.00 | |||
13 | 8/18/2021 | SLFR-111 | FOOD-12 | PR111 | NRIT12 | 85.00 | 25.00 | 60.00 | |||
14 | 8/19/2021 | SLFR-112 | FOOD-13 | PR112 | NRIT13 | 90.00 | 20.00 | 70.00 | |||
15 | 8/23/2021 | SLFR-116 | FOOD-17 | PR116 | NRIT17 | 40.00 | 10.00 | 30.00 | |||
16 | 8/24/2021 | SLFR-117 | FOOD-18 | PR117 | NRIT18 | 50.00 | 70.00 | -20.00 | |||
17 | 8/26/2021 | SLFR-119 | FOOD-20 | PR119 | NRIT20 | 45.00 | 5.00 | 40.00 | |||
18 | 8/27/2021 | SLFR-115 | FOOD-16 | PR116 | NRIT17 | 20.00 | 5.00 | 15.00 | |||
19 | 8/28/2021 | SLFR-116 | FOOD-17 | PR117 | NRIT18 | 35.00 | 10.00 | 25.00 | |||
20 | 8/30/2021 | SLFR-118 | FOOD-19 | PR119 | NRIT20 | 45.00 | 10.00 | 35.00 | |||
21 | 8/31/2021 | SLFR-119 | FOOD-20 | PR120 | NRIT21 | 25.00 | 20.00 | 5.00 | |||
22 | 9/1/2021 | SLFR-120 | FOOD-21 | PR121 | NRIT22 | 20.00 | 10.00 | 10.00 | |||
sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H2:H22 | H2 | =F2-G2 |
the result see the column BUYING(F) how add the mius value from column BALANCE(H) after change into puls and how become zero in column BALANCE(H)
COLOR2.xlsm | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | ITEM | SSTR | TTR | MMR | NNR | BUYING | SELLING | BALANCE | ||
2 | 8/7/2021 | SLFR-100 | FOOD-1 | PR100 | NRIT1 | 27.00 | 27.00 | 0.00 | ||
3 | 8/8/2021 | SLFR-101 | FOOD-2 | PR101 | NRIT2 | 30.00 | 20.00 | 10.00 | ||
4 | 8/9/2021 | SLFR-102 | FOOD-3 | PR102 | NRIT3 | 35.00 | 23.00 | 12.00 | ||
5 | 8/10/2021 | SLFR-103 | FOOD-4 | PR103 | NRIT4 | 30.00 | 25.00 | 5.00 | ||
6 | 8/11/2021 | SLFR-104 | FOOD-5 | PR104 | NRIT5 | 40.00 | 35.00 | 5.00 | ||
7 | 8/12/2021 | SLFR-105 | FOOD-6 | PR105 | NRIT6 | 45.00 | 10.00 | 35.00 | ||
8 | 8/13/2021 | SLFR-106 | FOOD-7 | PR106 | NRIT7 | 45.00 | 20.00 | 25.00 | ||
9 | 8/14/2021 | SLFR-107 | FOOD-8 | PR107 | NRIT8 | 65.00 | 65.00 | 0.00 | ||
10 | 8/15/2021 | SLFR-108 | FOOD-9 | PR108 | NRIT9 | 60.00 | 5.00 | 55.00 | ||
11 | 8/16/2021 | SLFR-109 | FOOD-10 | PR109 | NRIT10 | 70.00 | 10.00 | 60.00 | ||
12 | 8/17/2021 | SLFR-110 | FOOD-11 | PR110 | NRIT11 | 80.00 | 20.00 | 60.00 | ||
13 | 8/18/2021 | SLFR-111 | FOOD-12 | PR111 | NRIT12 | 85.00 | 25.00 | 60.00 | ||
14 | 8/19/2021 | SLFR-112 | FOOD-13 | PR112 | NRIT13 | 90.00 | 20.00 | 70.00 | ||
15 | 8/23/2021 | SLFR-116 | FOOD-17 | PR116 | NRIT17 | 40.00 | 10.00 | 30.00 | ||
16 | 8/24/2021 | SLFR-117 | FOOD-18 | PR117 | NRIT18 | 70.00 | 70.00 | 0.00 | ||
17 | 8/26/2021 | SLFR-119 | FOOD-20 | PR119 | NRIT20 | 45.00 | 5.00 | 40.00 | ||
18 | 8/27/2021 | SLFR-115 | FOOD-16 | PR116 | NRIT17 | 20.00 | 5.00 | 15.00 | ||
19 | 8/28/2021 | SLFR-116 | FOOD-17 | PR117 | NRIT18 | 35.00 | 10.00 | 25.00 | ||
20 | 8/30/2021 | SLFR-118 | FOOD-19 | PR119 | NRIT20 | 45.00 | 10.00 | 35.00 | ||
21 | 8/31/2021 | SLFR-119 | FOOD-20 | PR120 | NRIT21 | 25.00 | 20.00 | 5.00 | ||
22 | 9/1/2021 | SLFR-120 | FOOD-21 | PR121 | NRIT22 | 20.00 | 10.00 | 10.00 | ||
sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H2:H22 | H2 | =F2-G2 |
as you see the highlighted cells how changes . for instance in row 2 . -2 in column H should be 2 when add to column F , then =2+25=27 and the column H become 0and so on for any minus values should calculate with this way .