I want to find the percentage between two numbers. The first number in A1 is the stake and the second number in A2 is the winnings.
Is the formula in A3 the same whether the stake is less or more than the winnings?
Could you please give me the formula?
Many Thanks.
Last edited by tom hatten; 03-27-2013 at 04:11 PM.
A3 = sum(a1:a2)
B1 = a1/$a$3
B2 = a2/$a$3
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thank you for the quick reply but I'm confused by the formulas in B1 and B2. What are they and where do I put them?
In the percentage row I want to show the percentages won by each player (how much they've won in relation to how much they've staked).
Hi
a quick suggestion for your totals...use sumif(). in C35 copied across, use...
=SUMIF($B$3:$B$34,"Stake",C$3:C$34)
and in C36, use...
=SUMIF($B$3:$B$34,"Winnings",C$3:C$34)
Then in C37, copied across, use...
=C36/C35
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
Perfect! Thank you, FDibbins.
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks