Changing Cell location within a formula

Posted to microsoft.public.excel.programming

woknick[_2_] woknick[_2_] is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing location of comment when hovering over cell	doasidont	Excel Discussion (Misc queries)	2	March 9th 07 08:45 PM
Using Dynamic Cell Address As Formula Location	[email protected]	Excel Worksheet Functions	4	March 6th 07 06:37 AM
macro help for changing data (cell location) in edit find box	Jim	Excel Discussion (Misc queries)	1	November 10th 06 10:57 PM
how to auto increment cell location within formula	Bill	Excel Worksheet Functions	3	February 16th 06 02:23 PM
How can a formula get the location of the cell it is placed in?	Bernard[_4_]	Excel Programming	3	February 16th 04 02:35 PM

All times are GMT +1. The time now is 06:26 AM.

Menu

About Us