I would like to use a conversion table instead of using an if formula (due to a too large number of values that would make the if formula to complex).
Say that I calculate a weighted average on input from three different dimensions (A, B & C). Then I would like to convert that value based on data in a table with spans (from for example a google sheet), and present the value.
So basically if the output is (A*3+B*2+C*5)/10 I would like to compare that output with a conversion table and instead present the figure from a span in the conversion table. For example if the output is 1-5 present 22, if it's 5-10 present 48 and so on. The conversion table could be either somewhere in the code (?) or in a google sheet.