Hey team, I'm looking to find a formula to turn two numbers within two ranges into a letter. For example, if Player A's ranking is 37 and Player B's ranking is 164, is there a formula that's something like: if B2 is between 31-50 and D2 is between 101-200, put an A; if B2 is between 51-100 and D2 is 200+, put a B. Thanks guys!
Bookmarks