I'm looking for a fomula that determines a text result based on an average. The attached sample spreadsheet shows a matrix where answers to Events are recorded, summed and averaged. What I'm looking for is a formula (e.g. =if(?????) that checks the average by event and depending on where the numeric value falls in the range, it will apply the appropriate text.
I'm trying to solve for C9:C12. It should be populated with the text (e.g. Achieve, Partial, Invest, etc. etc.).
Hopefully, when you look at the sheet it will be self explanitory.