Hi Guys
I'm not too sure how to phrase this question so I'll just show you an example of what I have:
A B C D E F G H I
Priority 1 Priority 2 Priority 3 Total Claim To be subtracted Updated 1 Updated 2 Updated 3 Updated Claim
10 10 10 30(Sum A,B,C) 15 0 5 10 15
20 20 20 60(Sum A,B,C) 40 0 0 20 20
EDIT: I have just realized how hard this is to read on screen so I just attached a picture of what I mean. The yellow highlighted cells are the ones I need help formulating: http://imgur.com/a/jRnXG
Essentially I have a total claim, which is made up of a number of smaller claims which have a certain order of Priority.
Now I have a number to be subtracted from the total claim, but it has to be subtracted in the order of priorities stated. I then want an updated balance of all priorities and total claim.
Kind of like a waterfall, where I want to take all the money out of priority 1 first, before moving onto priority 2 etc etc.
Any help with this would be much appreciated!
I'm not too sure how to phrase this question so I'll just show you an example of what I have:
A B C D E F G H I
Priority 1 Priority 2 Priority 3 Total Claim To be subtracted Updated 1 Updated 2 Updated 3 Updated Claim
10 10 10 30(Sum A,B,C) 15 0 5 10 15
20 20 20 60(Sum A,B,C) 40 0 0 20 20
EDIT: I have just realized how hard this is to read on screen so I just attached a picture of what I mean. The yellow highlighted cells are the ones I need help formulating: http://imgur.com/a/jRnXG
Essentially I have a total claim, which is made up of a number of smaller claims which have a certain order of Priority.
Now I have a number to be subtracted from the total claim, but it has to be subtracted in the order of priorities stated. I then want an updated balance of all priorities and total claim.
Kind of like a waterfall, where I want to take all the money out of priority 1 first, before moving onto priority 2 etc etc.
Any help with this would be much appreciated!
Last edited: