LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Which Excel Functions Require Arrays to be Sorted? ExcelMonkey Excel Worksheet Functions 1 February 28th 07 09:42 PM
do you require up dates for office excel 2003 davd Excel Discussion (Misc queries) 1 September 14th 06 10:36 PM
IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA? LAKEISHA M. Excel Worksheet Functions 3 August 4th 06 07:24 PM
trying to create a formula and require help. Amste Excel Worksheet Functions 3 January 24th 06 08:25 PM
Require Tmplwiz.exe for Excel 2003 Gdoc Excel Discussion (Misc queries) 0 January 18th 06 10:59 PM


All times are GMT +1. The time now is 11:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"