Forum Discussion
Excel Kassenbuch Buchhaltung accounting
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.
PReagan that is Formula which I am currently using (typing it in manually) and it's either a + or - in the Formula. Depending if it's earning or expense.
And I am trying to find a solution for a Formula, where the formula checks, if the cell in B is a 0 and in Cell C it's any amount greater than Zero, the formula should use - and vice versa, if Cell B is any amount greater than 0 and in C it's 0, it should use + in the Formula.
Sorry if my explaining is difficult to read, but English is not my first language.
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!