![]() |
#1
|
|||
|
|||
![]() Range B2-D4: [1,1] [0,1] [1,1] Example: [-1,0] [0,0] [1,0] Cell F3 → [0,1] (ENTER X,Y) [-1,-1] [ 0,-1] [1,-1] Cell F4 → [7] (RESULTS) Range B6-D8: [5] [7] [6] Example: [8] [2] [3] Cell F7 → [0] (ENTER #) [0] [1] [7] Cell F8 → [-1,-1] (RESULTS) Would you please be so kind as to show me how to create a formula after entering any (x,y) coordinates in Cell F3, it will automatically display the corresponding number in Cell F4? Also, vice versa, where I would enter any number in Cell F7 and automatically display the corresponding (x,y) coordinates in Cell F8? Please note: Using MS Office 365. The (x,y) coordinates in range B2-D4 corresponds to the numbers in range B6-D8 I just made it 3x3 matrix to make it easier to understand what I needed to be done. Thanks! |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
eNGiNe | Word | 4 | 06-17-2018 11:05 PM |
![]() |
So New2 This | Word VBA | 1 | 10-17-2014 05:29 AM |
![]() |
Carchee | Excel | 7 | 06-13-2014 11:11 AM |
![]() |
rekent | Word VBA | 2 | 05-13-2014 06:53 AM |
![]() |
paulrm906 | Excel | 1 | 04-28-2006 07:35 AM |