Structured allotment

[djwaz69]

hi

i work on a excel sheet which consists of around 30 thousand rows of data (all shares) of 2000 clients, each client has multiple shares as a holding. I have classified 4 categories for the shares. (4 buckets). Client has take a loan for against those shares. i want to see the balance amount after liquidating the shares against (value after haircut) cell value in the order given below (100%;85%;75%,1%).

i have given 3 cases in excel attached. please help.. thanks in advance

4 buckets/ categories

1 ) 100%
2 ) 85%
3 ) 75%
4 ) 1%

[mrice]

I suggest providing a manually created example of what you are looking for as others might not understand the technical financial language.