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.
Hello Arian481,
I apologize if I am oversimplifying what you are asking. Perhaps this is what you're looking for?
PReagan it goes to the direction what I meant but it's not exactly what I need.
Here a picture of my current table (where I am typing the commans manually each row)
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.