Changing cell location with a formula

  • Thread starter Thread starter woknick
  • Start date Start date
W

woknick

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
 
If you mean the users would type in a the cell addresses in other cells you
should look at
INDIRECT or OFFSET

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Cell location within a formula 3
Insert Rows Problem 3
Excel Help to copy information from one row at a time to another sheet 1
insert new row and copy formula 1
Formula help 4
How do I find data excluded from a list in excel? 2
Sum Only Checked Checkboxes 3
Sum contents of multiple cells when the # of multiple cells is unk 5

Back
Top