Changing cell location with a formula

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
 
P

Peo Sjoblom

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
How do I find data excluded from a list in excel? 2
Sum Only Checked Checkboxes 3
insert new row and copy formula 1
Formula help 4
Formula returns #N/A 1

Top