Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-05-2019, 08:26 PM
arthurz11 arthurz11 is offline Enter x, y coordinates and displays a number Windows 10 Enter x, y coordinates and displays a number Office 2013
Novice
Enter x, y coordinates and displays a number
 
Join Date: Dec 2017
Posts: 11
arthurz11 is on a distinguished road
Default Enter x, y coordinates and displays a number


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!
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enter x, y coordinates and displays a number xref to heading 5.1 stubbornly displays 0 as heading number eNGiNe Word 4 06-17-2018 11:05 PM
Enter x, y coordinates and displays a number enter a constant based on entered number So New2 This Word VBA 1 10-17-2014 05:29 AM
Enter x, y coordinates and displays a number Enter a number in a locked equation within a cell that then calculates Carchee Excel 7 06-13-2014 11:11 AM
Enter x, y coordinates and displays a number VBA code to read number of footnote and enter in text rekent Word VBA 2 05-13-2014 06:53 AM
Enter x, y coordinates and displays a number Enter Number on any sheet one time only. paulrm906 Excel 1 04-28-2006 07:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft