Hi All, tried to look up the answer cause I know we covered this years ago 2005 ish. I needed to get same type answer/formula then but can't find the answer and can't remember how we did it.
So here goes:
I'm getting old and want to set up a will. I have a couple dollars in investments. have 9 people on a list. Right now I have them setup to get a dollar amount based on how much my investments are worth. So the total amount of the investments are 5,000 dollars today. I want to give varying amounts of 1,000 2,000 1,200 500 etc. So I think have to do it by percentages into what ever total will be going forward. Then using the number of people I have to assign them their percentage of the total 100% dollar amount. This make sense? So I'm trying things like count/sum to try to figure out each percentage but I'm just not getting it. Like I said getting old and haven't done this for many years and it isn't coming back.
Hope I have explained this adequately.
Last time we worked on something like this it involved an accounts payable system that YOU ALL helped me with. I had 33 cost centers that each had to pay a different amount based on the number of participants in the various cost centers. So each invoice was a different amount and quite often some of the cost centers didn't have to pay because they weren't involved. This was handled by the spreadsheet. I had a field that was yes on no a 1 or "blank" that added or ignored certain cost centers then use the ones picked to give their weighted average percentages and then multiplied them into the total bill to get their portion of the cost. I just remember it was a thing of beauty. For over 5 years it worked perfectly never so much as a penny off. And when you are talking tens of thousands of dollars in payments on each invoice it had to be right.
But I digress, then like now, any help would be appreciated.
Thanks
Walt
So here goes:
I'm getting old and want to set up a will. I have a couple dollars in investments. have 9 people on a list. Right now I have them setup to get a dollar amount based on how much my investments are worth. So the total amount of the investments are 5,000 dollars today. I want to give varying amounts of 1,000 2,000 1,200 500 etc. So I think have to do it by percentages into what ever total will be going forward. Then using the number of people I have to assign them their percentage of the total 100% dollar amount. This make sense? So I'm trying things like count/sum to try to figure out each percentage but I'm just not getting it. Like I said getting old and haven't done this for many years and it isn't coming back.
Hope I have explained this adequately.
Last time we worked on something like this it involved an accounts payable system that YOU ALL helped me with. I had 33 cost centers that each had to pay a different amount based on the number of participants in the various cost centers. So each invoice was a different amount and quite often some of the cost centers didn't have to pay because they weren't involved. This was handled by the spreadsheet. I had a field that was yes on no a 1 or "blank" that added or ignored certain cost centers then use the ones picked to give their weighted average percentages and then multiplied them into the total bill to get their portion of the cost. I just remember it was a thing of beauty. For over 5 years it worked perfectly never so much as a penny off. And when you are talking tens of thousands of dollars in payments on each invoice it had to be right.
But I digress, then like now, any help would be appreciated.
Thanks
Walt
