How do I convert simple table (12 rows / 2 coloums) to a function

%3CLINGO-SUB%20id%3D%22lingo-sub-2491773%22%20slang%3D%22en-US%22%3EHow%20do%20I%20convert%20simple%20table%20(12%20rows%20%2F%202%20coloums)%20to%20a%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2491773%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20following%20table%3A%3C%2FP%3E%3CTABLE%20width%3D%22141%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2277%22%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E18%3C%2FTD%3E%3CTD%3E0%2C87%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E27%3C%2FTD%3E%3CTD%3E1%2C51%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E36%3C%2FTD%3E%3CTD%3E2%2C21%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E45%3C%2FTD%3E%3CTD%3E2%2C9%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E54%3C%2FTD%3E%3CTD%3E3%2C86%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E64%3C%2FTD%3E%3CTD%3E6%2C38%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E73%3C%2FTD%3E%3CTD%3E8%2C54%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E81%3C%2FTD%3E%3CTD%3E11%2C49%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E90%3C%2FTD%3E%3CTD%3E13%2C4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E100%3C%2FTD%3E%3CTD%3E13%2C62%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3Eand%20I%20need%20a%20function%20which%20converts%20any%20input%20from%200%20to%20100%20(1st%20column)%20to%20the%20values%20in%20the%20second%20by%20interpolation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2491773%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2491909%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20convert%20simple%20table%20(12%20rows%20%2F%202%20coloums)%20to%20a%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2491909%22%20slang%3D%22en-US%22%3EI%20mean%20its%20pretty%20hard%20since%200%3D0%20and%209%3D0%20.%20lol%3C%2FLINGO-BODY%3E
Occasional Visitor

I have the following table:

00
90
180,87
271,51
362,21
452,9
543,86
646,38
738,54
8111,49
9013,4
10013,62

and I need a function which converts any input from 0 to 100 (1st column) to the values in the second by interpolation.

 

 

2 Replies
I mean its pretty hard since 0=0 and 9=0 . lol

@Lillevann 

As variant interpolation could be done as

image.png