Welcome Guest
Log In | Register )
You last visited December 7, 2016, 9:19 am
All times shown are
Eastern Time (GMT-5:00)

excel question

Topic closed. 1 reply. Last post 9 years ago by Luminus.

Page 1 of 1
PrintE-mailLink
Avatar

United States
Member #41846
June 23, 2006
459 Posts
Offline
Posted: August 5, 2007, 8:57 am - IP Logged

I have pick 4 data in b,c,d,e by col as drawn.

I have a second set of data that shows the abs difference b1,b2 etc

ex  in h1   =abs(b1-b2) 

my question. is there any way to put a number in a cell to modify one of the above cell references.  ex  i want to know the difference between b1 and b3  instead of b2 without having to change all the formulas 

p8

    Luminus's avatar - ouskuu

    United States
    Member #51269
    April 3, 2007
    529 Posts
    Offline
    Posted: August 5, 2007, 9:09 am - IP Logged

    You need to explain this better, because it's confusing.  Paste the excel table in here.  In any case, why not just make another row with a different formula?