Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Which Excel Functions Require Arrays to be Sorted? | Excel Worksheet Functions | |||
do you require up dates for office excel 2003 | Excel Discussion (Misc queries) | |||
IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA? | Excel Worksheet Functions | |||
trying to create a formula and require help. | Excel Worksheet Functions | |||
Require Tmplwiz.exe for Excel 2003 | Excel Discussion (Misc queries) |