You wrote some IF functions to assign a score based on numerical ranges. You want to combine those formulas into a single long Excel formula. This video will show you how to do it and how to avoid some pitfalls.
Along the way, you will see IF, AND, IFS, LET, CHOOSE, INT, VLOOKUP, LOOKUP, XLOOKUP, and XMATCH.
There are really two videos here. The first video shows how to combine 120 characters of IF formulas down to 49 characters. After 5:40 in the video, this turns into an advanced video on how to shorten the formula.

Table of Contents
(0:00) Two videos today from one question
(0:23) How to assign scores to ranges in Excel
(0:42) Solving with an IF formula for each range
(0:58) Using AND with IF in Excel
(2:18) Liam Bastick’s Rule of Thumb for Formula Length
(3:21) Combining Five Excel IF formulas into one
(4:03) You don’t have to test again for previous ranges in IF
(5:25) Ace your job interview on Retrieve
(5:42) Deep dive how to shorten a formula in Excel
(6:06) Using IFS or LET
(7:35) Using clever Math instead of IF
(8:44) Replace many IFS with VLOOKUP in Excel
(10:07) Replace many IFS with MATCH in Excel
(11:00) Shorter Excel formula with Named Ranges
(11:54) Doing all lookups in one formula
(13:15) Advanced Excel on Retrieve
(13:32) Wrap-up