Forum Discussion
Negative number change
Hi, 1-1-2023 NL89TRIO0254663206 107,35 Debet KN Kosten van 01-10-2022 tot en met 31-12-2022 1-1-2023 NL89TRIO0254663206 6.500,00 Credit A.P.C.van Tetering eo A.C.J.van Tet RABO...
Spreadsheets are a type of functional programming environment and formulas are prevented from making state changes of the type you describe. What you want could be achieved by a VBA (imperative programming) call that does use state changes.
Unless you want to use VBA event handlers, I suggest you leave the amount cell as it is and only introduce the 'debit' when you reference the data. You could, for example, introduce a named formula
signedAmount
= IF(Type="Credit", Amount, -Amount)Then you might have other spreadsheet formulas such as
= SUM(signedAmount)
= IF( signedAmount>0, 20% * signedAmount, 0 )