I’m trying to figure out how to make a cell autofill with a value from a table based on a percentage calculation. For example, if a percentage calculation ends up being between 75 and 79, the cell would autofill with the number 2. If the percentage ends up being 115-119, the cell would autofill with the number 7. I’ve tried to do it with the IF OR function, but I’m not well versed in excel and am having a hard time making heads or tails of it.
