Hi.
Got a couple of questions.
Firstly, if I'm wanting to get a value of a field, then subtract certain fields from the sum, then add some other fields, to do this, is this the correct way?
Basically each field (B16,C15) are paired like that, one is for an incoming sum in terms of balance.
Secondly.
Is it possible with this formula, so at the moment, it would subtract for example -E16 which would be like £10, but in E16 could I not type something for example "Rent", and using the defined field where I've specified a sum for rent elsewhere in the spreadsheet, could it then pull that sum and subtract it it that makes any sense?
Basically, rather than showing the sum of rent in that cell, I want it to show "rent" as it's easier to understand for me then, but that cell obviously needs a sum for the end cell with the above formula in to subtract it.
Thanks
Got a couple of questions.
Firstly, if I'm wanting to get a value of a field, then subtract certain fields from the sum, then add some other fields, to do this, is this the correct way?
Code:
=SUM(P15-C16,-E16,-G16,-I16,-K16,-M16,-O16+B16,+D16,+F16,+H16,+J16,+L16,+N16)Secondly.
Is it possible with this formula, so at the moment, it would subtract for example -E16 which would be like £10, but in E16 could I not type something for example "Rent", and using the defined field where I've specified a sum for rent elsewhere in the spreadsheet, could it then pull that sum and subtract it it that makes any sense?
Basically, rather than showing the sum of rent in that cell, I want it to show "rent" as it's easier to understand for me then, but that cell obviously needs a sum for the end cell with the above formula in to subtract it.
Thanks
Last edited:
