Forum Discussion

Pantarei's avatar
Pantarei
Copper Contributor
Mar 05, 2020

How to deduct a value from a total as I use it somwhere else

Hi guys, 

 

I know some of the formulas in Excel, but this is really driving me mad! I hope you will be able to shed some light on it! 

I have expenses of €2234 which total invoices I have from now till december (these are variable and the total has a formula that changes if the values change)

In another I have a fix amount I have available to pay those invoices, €2726

I want the total of my funds available to go down as I pay the expenses. 

basically, if at the moment i have €2726, and I use €300 of this to pay the invoices and my expenses go from €2234 to €1934, I also want €2726 to go down to €2426. 

 

Does it make sense? Can anyone help please?

Thanks!

 

Example: I have 

Formulas and Functions

2 Replies

  • NCRoy's avatar
    NCRoy
    Copper Contributor
    Mar 06, 2020
    Hi
    Just write a formula to Calculate Available fund . = 2726 - cell reference of paid amount.

    and to calculate expenses to pay : existing total formula - cell reference of paid amount

    Thanks

Resources