View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
woknick[_2_] woknick[_2_] is offline
external usenet poster
 
Posts: 1
Default 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