[Dropped] Automatic cash banking formula
Posted: Tue Nov 05, 2024 3:41 am
Hey,
I am not sure if it is at all possible, but here is the goal. I am trying to automatically get numbers from column Cashing Up to add up to Target in To be Banked. For example.
The to be banked should be automatically calculated from the cashing up as they are put in. I have tried a series of if statements like:
=IF(Cashing Total<Target;MIN(Cashing up; Target) per line to get the base values, but on each row calculate SumOf-Cashing Total<Target where sum of is all the rows above current(hopefully that made sense).
Two Problems I have run into, previous rows keep increasing and I get error messages when trying to pull numbers from a cell with a formula in it.
Plus trying to add a Mod Function to keep it to cash value, 20, 10, 5, 1, .5 etc, but that is a bonus rather than necessary for now.
Any Suggestions would be appreciated, been at this challenge for a few hours and I am close yet so far away.
I am not sure if it is at all possible, but here is the goal. I am trying to automatically get numbers from column Cashing Up to add up to Target in To be Banked. For example.
Target: 45.5 Cashing up | To be banked 20 20 50 20 30 5 2.5 0.5 Cashing Total: 45.5
The to be banked should be automatically calculated from the cashing up as they are put in. I have tried a series of if statements like:
=IF(Cashing Total<Target;MIN(Cashing up; Target) per line to get the base values, but on each row calculate SumOf-Cashing Total<Target where sum of is all the rows above current(hopefully that made sense).
Two Problems I have run into, previous rows keep increasing and I get error messages when trying to pull numbers from a cell with a formula in it.
Plus trying to add a Mod Function to keep it to cash value, 20, 10, 5, 1, .5 etc, but that is a bonus rather than necessary for now.
Any Suggestions would be appreciated, been at this challenge for a few hours and I am close yet so far away.