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)
 
Back
Top