interpolation of table

[MM_10735997]

@TudorMarin @Werner_E how can I make interpolated value of X2 for a specific value of C in Mathcad from given excel or from a mathcad table?

[Fred_Kohlhepp]

The function is Linterp!

[MM_10735997]

thank you for suggesting that function, but what if i have to get only value of 0.75, for value any less than 0.45 of CB and similarly to get value of 1.0 for X2 for any value of CB more than 0.7

[LucMeekes]

Linterp will extrapolate from the last two points. That's what Fred shows. If you add 0.75 for 0.4 (or 0) of CB, and 1 for 0.75 (or 1) of CB you should get your straight horizontal lines.

Success!

Luc

[LucMeekes]

Or:

X(C):=linterp(stack(0,CB,1),stack(0.75,X2,1),C)

Success!

Luc

[Perez · Accepted solution]

The propose solution below should work for you. It keeps the original data as is without adding extra rows. For any value less than or equal to 0.45, the value of X2 should be 0.75 and for any value equal or more than 0.7, the value of X2 should be 1: