View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Theresa Wright Theresa Wright is offline
external usenet poster
 
Posts: 1
Default calculate shares for heirs at law

does anyone have a calculation for shares for heirs at law? for instance, mrs smith dies, mr smith dies. no will. four children, one deceased with three children. so child 1 gets 1/4, child 2 1/4, child 3 1/4, grandchild 1, 2, 3 each share their deceased parent's 1/4th share, which is 1/12 each. this example is very very simple. i have a set spanning six generations with tons of deceased and living. which is why i need a spreadsheet calculation for this.