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.
