This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi newbie here! Hopefully someone can help me out… I’ve looked all over
and cant seem to find a solution. I have a table called worksheet and
I’ve created a slice to view only certain Category items . From there I
changed the sliced category items ty...
Is there a way to Interpolate (x, y, with known X value) between 2
tables? TABLE 1 TABLE 2 X! Y1 X Value Result 100 2,500 150 3050 200
3,600 300 4,200 Any help would be appreciated.
I’ve tried with no success so far. I keep running into list and number
compatibility issues using Index(),In(). I’m still new leaning this
platform and have spent a week trying to figure this out. I was able to
do it in Filemaker creating custom & ca...
Oops forgot to share the file. Try this one and you can edit it. Just
enter a value in the highlighted section. Thank you. docs.google.com
LINTERP Linterp PRICE TABLE,WORKSHEET TABLE,SPREAD SHEET RESULTS
AREA,COST,KNOWN AREA,INTERPOLATED COST,Index M...
Basically there are two tables. Table 1 (Pricing) contains 2 columns
with Multiple Rows, (X1 = Area) ( Y1 = Cost). Table 2 (Work Sheet)
contains 2 columns (X = Known Area) & (Interpolated Cost) for each new
record. Basically Known value is a quantity...