title: Generate words based on cell values
body: <p>[enter image description here][1]I haven't used Excel since high school (2004-2005) but I was pretty proficient in writing formulas back then based on static and dynamic cell values. I'm currently trying to make a spreadsheet that can keep up with statistical data based on yes and no inputs (or 1 and 0 if you prefer binary).</p>
  
  <p>In a game, I am managing a business and want to be able to keep track of employees based on their success. Success is a yes/no value. I'd like to have a table on sheet 2 that has the entire success/failure history of the player and on sheet 1 have a brief overview of their history that's listed on sheet 2 (overall success rate, success rate of last 10 inputs, and success rate of last 5 inputs).</p>
  
  <p>I may or may not be able to figure out the formulas for those. If not, I'll be sure to research before asking for help on that. What I can't figure out is how to assign a word value for a given success rate. For example, I'd like J7 to give a value of "Trusted", "Dependable", "Endorsed", or "Warning" based on the value in K7. If the value of K7 is 90%-100% J7 should populated "Trusted". If the value of K7 is 80%-89% J7 should populate "Dependable". If the value of K7 is 70%-79% J7 should populate "Endorsed". If lower than 70% J7 should populate "Warning".</p>
  
  <p>I'm trying to make the spreadsheet easy to use so that when I expand in the game I am able to share the spreadsheet with new branch owners to keep track of players working under them. That's why I would like the spreadsheet to be easy to manage so it doesn't take them long to figure it out and it doesn't take a long time to manage the spreadsheet so it doesn't rob them of game time.</p>
  
  <p>Thanks in advance :)</p>