• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Balance in sequence Positive negative

S P P

Member
Goodnight!
Balance in sequence Positive negative
 

Attachments

  • SPP Balance in sequence Positive negative.xlsx
    10.1 KB · Views: 12
Please use ABS formula
'=IF(AND(ABS(C2="Entrance";D2);D2;IF(AND(C2="Exit";D2);-D2;0)))
remove (-) negative from your formula below at the condition mentioned
=IF(AND(C2="Entrance",D2),D2,IF(AND(C2="Exit",D2),-D2,0))
 
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.
 
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
 
Back
Top