I’m working with data in Google Sheets. I have a list of information containing grades that are numerical on a scale of 0-100, as well as letter grades (A+, A, A-, etc.)
I need to get all this information in one clear format in my Google Sheets Sample. <https://docs.google.com/spreadsheets/d/1gddNvP2mnW9Fckk4p2u03R1LZucD1uIux0IeF9lLGIU/edit?usp=sharing> - All numerical scores from 90-100=A, 80=89=B, 70-79=C, 60-69=D, <60=F. - I also need to get rid of the A+ or A-, etc. designations and just have solid A, B, C, D, F letter grades. - This will eliminate the numerical scores and the A+,A-, etc. designations because they will be condensed into chunked, straight letter grade categories. Can someone help me fix this? I'm not sure what I'm doing wrong! I need every cell in the spreadsheet to convert, and creating filters and sorting to do manually is NOT an option with the amount of data I have to do this with! Thanks in advance! *Here's the Apps Script Code I created for the sample data I'm working with:* function scoreToGrade(range) { if (range >= 90) { return "A"; } else if (range <= 89) { return "B"; } else if (range >= 80) { return "B"; } else if (range <= 79) { return "C"; } else if (range >= 70) { return "C"; } else if (range <= 69) { return "D"; } else if (range >= 60) { return "D"; } else if (range > 59) { return "F"; } } function lettertoConvert(letter) { if (letter = "A+") { return "A"; } else if (letter = "A-" ) { return "A"; } else if (letter = "B+") { return "B"; } else if (letter = "B-") { return "B"; } else if (letter = "C+") { return "C"; } else if (letter = "C-") { return "C"; } else if (letter = "D+") { return "D"; } else if (letter = "D-") { return "D"; } } -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-spreadsheets-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/7156ca57-5e9e-48e8-8d86-24042623cdc9n%40googlegroups.com.