sorry, somehow i did not see the post #5 it was just visible to me now. i cant figure out why i could not see it. however, i have tried it, and
i think i missed a point here recovery always will be amount-first layer deductible, means if the amount is 58,504,967 then total recovery will be 58,504,967-15,000,000=43,504,967 from 1st till 2nd layer (1st will get max 15,000,000 and second 43,504,967-15,000,000=28,504,967 and the rest of the layers will be 0.
----
excel_learner
(Using XL 2007 & 2010)
-------Learning never stops!
In the file I had attached in post #5, use
C5=MIN(B5-C$3,C$3) and drag down
D5=MIN($B5-SUM($C$3,$C5:C5),D$3) and drag down and across
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Thank you so much, it works great
----
excel_learner
(Using XL 2007 & 2010)
-------Learning never stops!
Posting Permissions
Reply With Quote
Bookmarks