Dear friends,
I need some help in calculating
AMOUNT 42400 is distributed among 6 people (C) in percentage if any of them or any 2 of them is deleted their contribution percentage need to be distributed among other
i am attaching the example sheet...
please look into it.
Thanks in advance.
Senjuti
I dont know where you are getting your % from in your calcs, and if you are basing the amount on the total contribution, then if you delete 2 names, their contribution to the total will be gone, so the total will be less?
However, try this...
=$C$13*B4/$B$13
or
=42400*B4/$B$13
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks