+ Reply to Thread
Results 1 to 4 of 4

Adding Numbers without Carry

  1. #1
    Registered User
    Join Date
    06-12-2008
    Location
    Mi.
    MS-Off Ver
    excel 2007
    Posts
    60

    Adding Numbers without Carry

    Do you know the formula for the VTRACS in excel????
    VTRACS IS JUST A NAME---

    Example:
    A-row----B-row-----C-row
    MD------EVE--------TOTAL
    456-----223--------679
    337-----127--------454
    896-----589--------375

    Looking for the formula to go in
    C-ROW to get 679--454--375???
    I am adding A row and B row to get
    the results in C-row---
    Adding with no carry over----
    What is the formula to use in C-ROW???

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    There is surely an easier way to do this ...

    =RIGHT( INT(A1/100) + INT(B1/100)) & RIGHT( INT(A1/10) + INT(B1/10)) & RIGHT(A1+B1)
    Last edited by shg; 07-25-2008 at 05:18 PM.

  3. #3
    Registered User
    Join Date
    06-12-2008
    Location
    Mi.
    MS-Off Ver
    excel 2007
    Posts
    60

    Shg

    SHG

    Thanks---
    that works good for me--

    Bob in michigan

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    I like Ron Coderre's approach in http://excelforum.com/showthread.php?t=651095 better:

    =SUM(MOD(MID(A1, {1,2,3}, 1) + MID($B$1, {1,2,3}, 1), 10) * {100,10,1})

+ 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