Forum Discussion
Solved
Excel Kassenbuch Buchhaltung accounting
Hallo liebe Community, Ich möchte ein Kassenblatt (Kassenbuch ähnliche Variante) führen für das Taxiunternehmen von meinem Vater. Folgendes Problem versuche ich bei der Tabelle jetzt zu lösen...
I am not understanding why you would need to manually change "+" or "-". Your screenshot shows that column B contains only earnings while column C contains only expenses. If this is the case, then use =D6+B7-C7 in cell D7.
There is no need to test whether cell in B is 0 or cell in C is 0 because B will always be added (since it is a revenue) and C will always be subtracted (since it is an expense) from D.
THANKS A LOT !!! and now I feel terribly stupid .... it's soooo obvious .... but to defend myself: I am a beginner in excel and never had to use it before for such a case ... ( It's a cheap excuse I know 😄 )
Anyway .. much appreciated and again thanks for your help!