scores

Hi, this is probably the most basic formula but I just can't get it to work so I apologize for being slow. =IF(D3<E3,"LOSE","WIN") At present it is showing as LOSE as D3 and E3 are blank. I don't want it to show a result until the scores are input to D3 and E3. How can I do this?

Hi, I'm trying to compile a "leaderboard" for our weekly quizzes, which since the start of the pandemic have become our mainstay social activity (and good fun they are too). It's only among friends but can get pretty competitive! I have produced a spreadsheet to record the weekly scores, but...

Hello, I have registered in this forum to ask a specific question about something that I was told it's possible and you can help me to find out how to do it. I am doing an experiement in which I ask participants to listen to 40 short phrases in German (e.g., Die Haeuser sind sehr schoen) and...

Hello. I need help designing a macro. I have no clue how to do it, never done a macro yet. I want to import into an excel file, the games and the scores from a web site (ie. FlashScore.com: Live Football Scores, Livescore ). I want to assign this macro to a button, so I can refrash the data...

Hello, Is there a way to have a result of the top 5 highest scores? Here's my example. Entered manually: A1 = Dan - B1 = 63 A2 = Bill - B2 = 54 A3 = Steve - B3 = 73 A4 = Ben - B4 = 38 A5 = Patrick - B5 = 45 A6 = Jack - B6 = 104 A7 = Craig - B7 = 73 I put the tie on...

Hi all, I'm working on a pretty hefty spreadsheet right now which will tally scores during our application review process. The sheet currently has 3 sheets, one with raw scores, one with weight values, and one where I'm multiplying raw scores by their weight values to get weighted scores. The...

Hi Guys Hope this is possible. I have a neat little single dice roll set up, but now that is working, I want to "store" the results of each roll in consecutive cells. So, dice roll 1 scores a 5 store in cell G1 dice roll 2 scores a 3 store in cell G2 dice roll 3 scores a 1...

I have a database that produces reports about tests taken by students all on one row. The data always includes a test name, test date, and one or more scores. E.g.: <tbody> Test Date Algebra Geometry Arithmetic Test Date Spelling Math 2/2/2019 40 50 60 English 2/5/2019 70 </tbody>...

Hi guys, I hope you can help. I have a leaderboard based on certain scores. It update automatically and puts people’s names in order based on their scores, but doesn’t show their scores next to their name. I’ve tried a simple lookup formula but it doesn’t appear to be working. Cells...

Hi guys, Need some experts to shed light on me. Trying to come up with a formula to get how many 100% scores do I need to get to 98% if my table looks like this: <colgroup><col><col><col><col></colgroup><tbody> Current Attempts Running Score Goal How many 100% audits needed? 87 96% 98%...

Hello guys, I hope you can help. I have a sheet that basically has names and scores, the names are in cells B3-B10 and their scores are in cells Z3-Z10. This is part of a scoreboard with other bits in between them so everything needs to stay where it is, however I would like to put a live 1st...

Hello, I am new and have no idea what I am asking but we all have to start somewhere so here goes... I have rows of test scores for different students that at the end in a column are calculated to give me the average for each row so there is an average function in each of the cells in that...

I have a spreadsheet that presents the results from a test.The number of columns depends on the number of questions and the number of rowsdepends on the number of test takers. I need to look across row 4 and where ever the word “Score”appears I need to average the list of scores in the rows...

Good Morning, I am working with some test DATA, i am a teacher, and i have three columns A1 B1 C1 Increase (the difference between the scores) New Scores Old Scores In the increase column i am...

Hi everyone, I'm working on a spreadsheet to calculate average scores from a given range,where they're 0-100. What I have is working fine, however for the purpose ofranking the averages I need to treat scores that are < 75 as “50” whencalculating the averages. Eg. Scores are 100, 89, 85, 76...

Hi Guys, A little bit of help. =(B2*C2+B3*C3+B4*C4)/SUM(B2:B4) This is my formula for getting the average percentage of average percentages but what is I have more than 3 rows that needs to average? Let's say 100 rows of average scores. How do I shorten my formula? Thanks! <tbody> SKILL...

Hello How would I create a formula that updates automatically when I update/change the selections in my spreadsheet filters? I have a large spreadsheet with columns for school names, teacher names, class names, subjects, students and columns for test scores. I need to count the number of test...

Hi everyone. First post here and I need some help. I'm setting up a scoring sheet for a golf course that needs to calculate what we call a "quota". Your quota is an average of your top 3 scores from your 5 most recently played. I have the easy stuff done. A player's score is entered into a...

I have a spreadsheet that calculates handicap changes - I would like script (if possible) to do the following: The first step is that the total cell (for each row) picks up the last 3 scores if they qualify A formula will then decide if a handicap change is due. However if a handicap is...

This seems like a simple problem, but I'm stuck. Right now I'm on the verge of a giant, if(and(or statement to look at every possible outcome, but I think there has to be an easier way. I'm assuming this is an array formula of some type, but I am not skilled enough to figure it out. I have a...