View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] slsjmc@yahoo.com is offline
external usenet poster
 
Posts: 4
Default Excel Chart - Require a Formula

I have the attached chart (no titles). I am trying to create a
formula to calculate the example that is listed below the chart, which
is of course, based on the numbers in the chart. I would like to have
it so that someone would type the 2 digit number on the left (listed
in the example below the chart) and the next column would
automatically give the user that typed the 2 digit number, the 1 digit
number result (based on the chart). Ex: the user would type 41 and
the result next to it would be 4 (the chart is for information only,
it is the calculation underneath the chart that I require but it is
based on numbers obtained from the chart). If anyone knows a formula,
I would appreciate it, along with a brief explanation of the formula
as I do not understand when it becomes really technical (I am a basic
user).

- 0 1 2 3 4 5 6 7 8 9 the dash is a blank cell
0 0 8 6 4 2 9 7 5 3 1
1 9 7 5 3 1 8 6 4 2 0
2 8 6 4 2 0 7 5 3 1 9
3 7 5 3 1 9 6 4 2 0 8
4 6 4 2 0 8 5 3 1 9 7
5 5 3 1 9 7 4 2 0 8 6
6 4 2 0 8 5 3 1 9 7 5
7 3 1 9 7 5 2 0 8 6 4
8 2 0 8 6 4 1 9 7 5 3
9 1 9 7 5 3 0 8 6 4 2

CHART works this way:
Here is the number: 41619306 that we have. A person would input the
2 digit number on the left below (based on chart above, which they may
or may not be able to see - doesn't matter). I want the number on the
right (1 digit) to automatically appear based on the chart above. The
41 show that you start at the 4 on the vertical column and go across
to the 1 on the horizontal column, which results in the 1 digit number
4, etc.
Breakdown:
41 = 4
61 = 2
93 = 5
06 = 7

Thank you.