Excel formula to distribute one value in three different sites with different percentages
Attached file is for excel 2010 and removed the formatting from this file.
I want to distribute 50, 100, 200 and 300 in three different places with mentioned percentage in front of each value with a condition that this percentage should always bee in total 100. Value of each site A, B & C shall come in blank set. Thanks for assistance.
Last edited by hussainahmad; 05-23-2014 at 09:35 AM. Reason: VALUE I POSTED EARLIER GET MERGED
Can't tell where your numbers are due to loss of formatting. Uploading a spreadsheet with expected results would fix that (Go Advanced>Manage Attachments)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks chemist for your qucik reply, i removed all the formatting from the file and this is Excel 2010 file. Its like, you may put any value in one cell and distribute this amount between three persons with the condition that full amount is been distributed and nothing is balance. I mean you may assign three different percentages for three persons or person remain three but percentage could have been changed to two but percentage total will remain 100%
In F2 copied across and down
=IF(SUM($B2:$D2)=1, $A2*B2,"Not 100%")
Does this work for you?
I LOVE YOU MY FRIEND, SUPERB ! Its Done. Thanks for your quick assistance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks