Intervals in cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1316855%22%20slang%3D%22en-US%22%3EIntervals%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1316855%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20with%20a%20norm%20table%2C%20i.e.%20I%20have%20ranges%20of%20raw%20scores%20that%20I%20want%20to%20translate%20into%20scaled%20scores.%20I%20have%20a%20table%20in%20the%20format%200-7%20is%20equivalent%20to%20scaled%20score%201%2C%208-11%20to%202%20and%20so%20on%2C%20and%20counted%20on%20using%20some%20of%20the%20lookup%20formulas.%20Is%20there%20any%20possibility%20for%20Excel%20to%20read%20expressions%20like%200-7%2C%20and%208-11%20or%20do%20I%20have%20to%20convert%200.7%20to%200%2C%201%2C%202%2C%203%20and%20so%20on%20in%20separate%20cells%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1316855%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1317606%22%20slang%3D%22en-US%22%3ERe%3A%20Intervals%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1317606%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F587660%22%20target%3D%22_blank%22%3E%40Aniara625%3C%2FA%3E%26nbsp%3BYou%20may%20use%20either%20LOOKUP%20or%20VLOOKUP%20to%20do%20this%2C%20if%20you%20also%20create%20a%20small%20table%20with%20the%20brackets%20for%20your%20scaling%20of%20norms.%20In%20the%20attached%20example%2C%20scale%201%20starts%20at%200%2C%20scale%202%20at%208%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20the%20most%20recent%20version%20of%20Excel%2C%20you%20might%20even%20use%20XLOOKUP.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1317628%22%20slang%3D%22en-US%22%3ERe%3A%20Intervals%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1317628%22%20slang%3D%22en-US%22%3E%3COL%3E%3CLI%3EMany%20thanks%2C%20and%20of%20course!%20Thanks%20for%20helping%20me%20with%20this!!!%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am working with a norm table, i.e. I have ranges of raw scores that I want to translate into scaled scores. I have a table in the format 0-7 is equivalent to scaled score 1, 8-11 to 2 and so on, and counted on using some of the lookup formulas. Is there any possibility for Excel to read expressions like 0-7, and 8-11 or do I have to convert 0.7 to 0, 1, 2, 3 and so on in separate cells?

2 Replies
Highlighted

@Aniara625 You may use either LOOKUP or VLOOKUP to do this, if you also create a small table with the brackets for your scaling of norms. In the attached example, scale 1 starts at 0, scale 2 at 8 etc.

 

If you are the most recent version of Excel, you might even use XLOOKUP.

Highlighted
  1. Many thanks, and of course! Thanks for helping me with this!!!