Outflow & Inflow of cash balance

%3CLINGO-SUB%20id%3D%22lingo-sub-2624853%22%20slang%3D%22en-US%22%3EOutflow%20%26amp%3B%20Inflow%20of%20cash%20balance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2624853%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20struglling%20with%20figuring%20out%20a%20formula%20that's%20supposed%20to%20do%20so%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EWhen%20I%20put%20in%20a%20value%20to%20%3CEM%3Einvestment%3C%2FEM%3E%20(column%20A)%2C%20%3CSTRONG%3Eit%20withdraws%3C%2FSTRONG%3E%20that%20invested%20amount%20from%20%3CEM%3Ecash%20balance%3C%2FEM%3E%20(column%20C).%20In%20other%20words%20funding%20an%20investment%20from%20cash%20balance.%3C%2FLI%3E%3CLI%3EReversely%2C%20when%20I%20exit%20an%20investment%26nbsp%3B(column%20A)%20(e.g.%20taking%20profit%20or%20loss)%20I%20want%20the%20value%20of%20column%20A%20(which%20is%20the%20initial%20fund)%20to%20be%20summed%20with%20Realized%20Profit%2FLoss%20(column%20B)%20and%20flow%20back%20into%20the%20cash%20balance%20(column%20C).%26nbsp%3B(Column%20A%20will%20then%20be%200%24%20in%20value%3B%20Realized%20P%26amp%3BL%20(column%20B)'s%20value%20remains).%20Thanks%20a%20lot%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Sn%C3%ADmek%20obrazovky%20(101).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F301614i6446F3720B3ABCFB%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Sn%C3%ADmek%20obrazovky%20(101).png%22%20alt%3D%22Sn%C3%ADmek%20obrazovky%20(101).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2624853%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2625007%22%20slang%3D%22en-US%22%3ERe%3A%20Outflow%20%26amp%3B%20Inflow%20of%20cash%20balance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2625007%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1123293%22%20target%3D%22_blank%22%3E%40HungTa%3C%2FA%3E%26nbsp%3BThis%20would%20do%20the%20trick%20though%20it%20will%20not%20clear%20out%20Column%20A%20when%20you%20enter%20a%20profit%20or%20loss%20in%20B.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-08-08%20at%2016.47.17.png%22%20style%3D%22width%3A%20342px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F301620i5C93BD461A666B61%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-08-08%20at%2016.47.17.png%22%20alt%3D%22Screenshot%202021-08-08%20at%2016.47.17.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hi, I'm struglling with figuring out a formula that's supposed to do so: 

 

  1. When I put in a value to investment (column A), it withdraws that invested amount from cash balance (column C). In other words funding an investment from cash balance.
  2. Reversely, when I exit an investment (column A) (e.g. taking profit or loss) I want the value of column A (which is the initial fund) to be summed with Realized Profit/Loss (column B) and flow back into the cash balance (column C). (Column A will then be 0$ in value; Realized P&L (column B)'s value remains). Thanks a lotSnímek obrazovky (101).png
1 Reply

@HungTa This would do the trick though it will not clear out Column A when you enter a profit or loss in B.

Screenshot 2021-08-08 at 16.47.17.png