I'm trying to create a score sheet for pinochle to use in Excel. The online formulas don't work properly.
I've attached an example of scoring and what I'd like the formulas to do.
Any help would be greatly appreciated.
I'm trying to create a score sheet for pinochle to use in Excel. The online formulas don't work properly.
I've attached an example of scoring and what I'd like the formulas to do.
Any help would be greatly appreciated.
Welcome to the forum.
This:
=IF(B7+B8>B6,B7+B8,-B6)
and this:
=IF(B11+B12>B10,B11+B12,-B10)+B9
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Those formulas worked great, but there is one more adjustment.
The following works if everyone makes their meld, but if you don't get 10 tricks, you lose your meld. That is the addon needed.
IF TRICKS (B12) PLUS MELD (B11) ARE GREATER THAN BID (B10), THEN ADD B11, B12 AND B9.
IF TRICKS (B12) PLUS MELD (B11) ARE LESS THAN BID (B10), THEN ADD NEGATIVE B10 AND B9.
IF TRICKS ARE LESS THAN 100 (100 IS FINE), THEN DON'T ADD ANYTHING AND BRING PREVIOUS TOTAL DOWN TO B17.
Additional issue. Okay, those formulas worked but I discovered another issue and can't for the life of me figure out how to create the formula. Everything is explained in the file.
TIA
Last edited by jwpickett; 03-12-2021 at 03:39 AM. Reason: change
Searching the internet using the search term "excel pinochle score sheet" I see a lot of free score sheets.
The one from listia.com looks pretty much like the one in the file attached to post #3.
You may want to try some of them to see if they will do what you want.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Is the formula shown in cell F41 what you would use for the player that takes the bid and the formula shown in cell F42 what you would use for those that do not?
If so try pasting the following into cell B42 and dragging the fill handle over to cell D42:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
It's not necessarily who takes the bid. Line 42 is what the actual totals should be. In this case B player (column) didn't make the necessary 200 tricks so goes set the 620. Player D column took the bid in line 43(D43) and that total is correct. However, if you look at D31, the sum of D32 and D33 is equal to D31, therefore the bid is made, but the formula subtracts the bid, and shows up as 2680 when it should read 4180. I found the segment in the formula that involves this, and changed it to
.....................(IF(SUM(D32:33)=>D31,SUM ...so it now reads:
=IF(AND(ISNUMBER(D31),D33<200),D30-D31,IF(D33<100,D30,(IF(SUM(D32:D33)>=D31,SUM(D30,D32:D33),D30-D31))))
That formula replicated throughout the total lines brings the score correct with my paper scoresheet.
Thanks to all.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks