 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2007subtracting a range from another range and getting a range result
I have two ranges of XYZ coordinates. One is named R1 and the other R2. Is there any way in Excell 2002 to bascially say R2-R1=R3 so that R3 is a range the same size as R1 and R2, where each cell in R3 is is subtraction of the corrisponding cells in R1 and R2? Sort of like this: r1= 3,4,5 r2=3,4,5 r3=6,8,10 of course I need to do this on a two dimentional range, there are multiple XYZ points. Are the three values of R1 (3,4,5) in separate cells? Are you adding or subtracting? Please spell out the problem in more detail  SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email >I have two ranges of XYZ coordinates. One is named R1 and the other > R2. Is there any way in Excell 2002 to bascially say R2-R1=R3 so that [quoted text clipped - 8 lines] > of course I need to do this on a two dimentional range, there are > multiple XYZ points. On Feb 1, 4:52 pm, "Bernard Liengme" <blien...@stfx.TRUENORTH.ca> wrote: > Are the three values of R1 (3,4,5) in separate cells? > Are you adding or subtracting? > Please spell out the problem in more detail Ok, let me try again: A | B | C | D | E | F | G | H | J | K | L 1| 3 4 5 2 3 4 5 7 9 2| 4 5 3 4 2 3 8 7 6 RANGE1 = (A1:C3) RANGE2 = (E1:G3) is there any wan in Excel to say RANGE1 + RANGE2 and get a RANGE3 in (J1:L2)? In J1: =A1+E1 Copied across to L1 then down Biff > On Feb 1, 4:52 pm, "Bernard Liengme" <blien...@stfx.TRUENORTH.ca> > wrote: [quoted text clipped - 13 lines] > is there any wan in Excel to say RANGE1 + RANGE2 and get a RANGE3 in > (J1:L2)? > In J1: > > =A1+E1 > > Copied across to L1 then down I am trying to do it programmatically. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.