I'm hoping that this is much simpler to do than it is to explain. I
attempted to upload the .xls file but got an invalid file message.
I'm looking for a formula to find the intersection on a graph. The user
will input a width and a height and those numbers need to be rounded up
to the nearest .25 to match the axis of the graph. (This can be a
separate formula if that makes it any easier). Then the largest of
those numbers should be referenced to the horizontal axis (Row 1) and
the smaller of those numbers to the vertical axis (Column A) of the
graph and the intersection be found.
Example:
On sheet 1, B4=height, B3=width. These are filled out by the user. If
for example they enter 2.339 in A1 (or anything above 2.25 but less
than or equal to 2.50) it would be rounded up to 2.50. Then if they
enter a lower number - let's say 1 - in B1, then the formula would
lookup both numbers on Sheet 2 and reference the lower number (1) to
the vertical axis and the higher number (2.5) to the horizontal axis
and find the intersection.

Sheet 2 is titled Engraving Scale and is labeled with Row 1 being the
horizontal axis as follows:
A1=0
B1=.25
C1=.5
D1=.75
E1=1
F1=1.25
etc thru CK1=22

Column A is the vertical axis and is as follows:
A69=0
A68=.25
A67-.5
A66=.75
A65=1
A64=1.25
etc thru A2=16.75

In every column from Row 2 through Row 68 are numbers that are to be
referenced by the intersection of the height and width.

Thanks so much. You guys work miracles!
Please let me know if I've not explained myself well.


--
pdgood
------------------------------------------------------------------------
pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623
View this thread: http://www.excelforum.com/showthread...hreadid=522444