How about doing a linear regression of the line (assuming it's linear) and
calculating the value of Y from your known X. Use the LINEST function to
get you there.
"lifeguard_911" wrote:
I need to find a value on the line of a chart that I did for chemistry. It
isn't one of the points in my table of values. I have the x value, but need
to know the y value. Thanks in advance for anyone's help.
|