Good afternoon,
I am building a scores table for a pub quiz. One of the rules are that teams can use a trump card in one round which will double their points.
I have created a data validation list where the scorer can select what round the team have chosen to use their trump card but need a formula that will automatically double the the score for the round once it is entered.
Is anyone able to help?
Last edited by Challenger40; 12-18-2019 at 12:25 PM.
Hi Challenger40,
Welcome to the Forum.
We probably can help but would need a copy of your file.
Please follow the instructions in the yellow "banner" just above your post and add a copy of your file.
regards
peterrc
Thank you for getting back to me peterrc. I have uploaded the file. I have formatted it so when you say which round you are playing the trump card the cell turns yellow but I need to multiply the value of the cell by two automatically when it is populated.
What goes into the trump card column to indicate that the card is being used? There is no conditional formatting that I can see.
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.
The number of the round then it fills by colour
Doesn't work!
Anyway, that doesn't really matter for the question in hand. Try this:
=SUM(E5:I5)+INDEX(E$5:I$5,,D5)
Excel 2016 (Windows) 32 bit
Sheet: Sheet5
Excel 2016 (Windows) 32 bit
Sheet: Sheet5
Works great thank you so much. Have a great festive season
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Happy Christmas!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks