This isn't the kind of thing that Excel has built into it, but it
certainly is capable of the calculations necessary. Do you just have a
table of data or do you have an analytic function [y=f(x)] for the grain
size that you could use to calculate x at y=.6?
If you have the function, then it would be easy enough to solve the
equation for y=.6 either analytically or numerically (using Solver/Goal
seek).
If you don't have the function, you could curve fit the tabulated data
to a reasonable function and then use that to estimate x at y=0.6.
You could also use an interpolation routine (linear interpolation is by
far the easiest to implement) to estimate x at y=0.6. Excel doesn't
have a built in interpolation routine, but you could build one either
with worksheet functions or in VBA.
If all else fails, you could visually pick the value off of the chart.
--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile:
http://www.excelforum.com/member.php...o&userid=22181
View this thread:
http://www.excelforum.com/showthread...hreadid=487303