Forum Discussion
IF, IFS or maybe some other formula?
This is probably pretty easy, but I can't make it work, been trying different formulas without success, and now I need help! In one column I have values raging from -3,00 to 3,00. In the other co...
Perhaps you may provide small sample. It's not clear, at least for me, which average to take and what "so on" means.
Of course, I'm sure I've described it poorly ... Perhaps I can explain it better! I can upload a sample, but let me try do describe it better first!
My values can be anywhere between +3 and -3 (z-scores). For every value there is a description/interpretation. Instead of having to look up every value in a chart, for example this one: https://www.ritenour.k12.mo.us/cms/lib011/MO01910124/Centricity/Domain/69/Psychometric_Conversion_Table.pdf
.. I would like Excel to do it for me!
Does it make sense? 🙂