+ Reply to Thread
Results 1 to 2 of 2

Using four columns to produce another column

  1. #1
    Registered User
    Join Date
    01-31-2008
    Posts
    1

    Using four columns to produce another column

    Hi,

    I am new here. I hardly ever used excel. Anyways. I have to find a way to do this so here goes:

    I would like to make a column of numbers from four columns of numbers for ALL components of those columns. For e.g.

    | C1 | C2 | C3 | C4 | C5 |
    | x1 |x2 | y1 | y2 |sqrt[((x1-x2)^2) + ((y1-y2)^2)] |

    Can anybody tell me?

    Thanks.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    If your numbers are in the range A2:D2 then
    E2: =SQRT((A2-B2)^2+(C2-D2)^2)

    rylo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1