Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell location within a formula
How can change the cell locations within a formula. Here is my formula
=SQRT((B8-B7)^2+(C8-C7)^2) I want to be able to substitute user inputs for the B7,B8,C7, and C8. Please let me know how to change those locations to variables. thanks in advanc -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell location within a formula
Hi
set up an area of the worksheet to be where your users input the cell references they want to use i've chosen A11:A14 then change the formula as follows =SQRT((INDIRECT(A11)-INDIRECT(A12))^2+(INDIRECT(A13)-INDIRECT(A14))^2) Regards JulieD "woknick " wrote in message ... How can change the cell locations within a formula. Here is my formula =SQRT((B8-B7)^2+(C8-C7)^2) I want to be able to substitute user inputs for the B7,B8,C7, and C8. Please let me know how to change those locations to variables. thanks in advance --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell location within a formula
assume the user will enter the cell addresses in A1 to A4. For example, to
use your existing addresses: A1: B8 A2: B7 A3: C8 A4: C7 then your formula would be =SQRT((INDIRECT(A1)-INDIRECT(A2))^2+(INDIRECT(A3)-INDIRECT(A4))^2) -- Regards, Tom Ogilvy "woknick " wrote in message ... How can change the cell locations within a formula. Here is my formula =SQRT((B8-B7)^2+(C8-C7)^2) I want to be able to substitute user inputs for the B7,B8,C7, and C8. Please let me know how to change those locations to variables. thanks in advance --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell location within a formula
That seems like that will work, lets say I have 2 colums of numbers:
X and Y 2 6 3 8 3 5 5 4 reference 9 and 4 and I want excel to use a fixed user input for the B7 and C7 and hav the program step through the displayed X and Y numbers example: =SQRT((2-9)^2+(6-4)^2) =SQRT((3-9)^2+(8-4)^2) and so on. I need excell to step through each number. Thanks in advanc -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing location of comment when hovering over cell | Excel Discussion (Misc queries) | |||
Using Dynamic Cell Address As Formula Location | Excel Worksheet Functions | |||
macro help for changing data (cell location) in edit find box | Excel Discussion (Misc queries) | |||
how to auto increment cell location within formula | Excel Worksheet Functions | |||
How can a formula get the location of the cell it is placed in? | Excel Programming |