Goodnight! Balance in sequence Positive negative
S S P P Member May 19, 2021 #1 Goodnight! Balance in sequence Positive negative Attachments SPP Balance in sequence Positive negative.xlsx 10.1 KB · Views: 12
B basu New Member May 20, 2021 #2 basu said: Please use ABS formula '=IF(AND(ABS(C2="Entrance";D2);D2;IF(AND(C2="Exit";D2);-D2;0))) Click to expand... remove (-) negative from your formula below at the condition mentioned =IF(AND(C2="Entrance",D2),D2,IF(AND(C2="Exit",D2),-D2,0))
basu said: Please use ABS formula '=IF(AND(ABS(C2="Entrance";D2);D2;IF(AND(C2="Exit";D2);-D2;0))) Click to expand... remove (-) negative from your formula below at the condition mentioned =IF(AND(C2="Entrance",D2),D2,IF(AND(C2="Exit",D2),-D2,0))
Excel Wizard Active Member May 20, 2021 #3 Please try at E2 =SUM(E1,(1-2*(C2="Exit"))*D2) Attachments SPP Balance in sequence Positive negative.xlsx 11 KB · Views: 5
S S P P Member May 20, 2021 #4 basu Good Morning! I couldn't use your formula. It didn't work check. Excel Wizard Good Morning! It worked perfectly, the way I need it. Thanks again.
basu Good Morning! I couldn't use your formula. It didn't work check. Excel Wizard Good Morning! It worked perfectly, the way I need it. Thanks again.
S S P P Member May 20, 2021 #5 I could have used the same formula in E3 by adding + E2 =IF(AND(C3="Entrance";D3);D3;IF(AND(C3="Exit";D3);-D3;0))+E2 But the alternative was worth i
I could have used the same formula in E3 by adding + E2 =IF(AND(C3="Entrance";D3);D3;IF(AND(C3="Exit";D3);-D3;0))+E2 But the alternative was worth i