Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
@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?
Solved! Go to 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:
The function is Linterp!
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
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
Or:
X(C):=linterp(stack(0,CB,1),stack(0.75,X2,1),C)
Success!
Luc
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: