Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
Hi All, I have a variable x that can be calculated by a function. I also have an array to determine the practical numbers that can be used in this variable. I want to use lookup information to find the closest information from the array based on the calculation results. However, it seems like the guides in PTC Mathcad Help cannot really solve my problem. Would anyone take a look at the attached worksheet? Thank you!
Solved! Go to Solution.
Hi Richard, would you tell me how can I modify this IndexOfNearest function, to return the value that "the closest value to the calculated one among all values smaller than calculated one"? Thank you!