Add numbers within a cell

  • Hi


    I need to add numbers within a cell. for example...one of the cells is a total of a range of cells..say total is 43...now I need to add 4 + 3 and display the results (7) in another cell.


    The book that describes this calculation has refered to it as cross-addition and/or laterally add numbers.


    Thanks for your help in advance.

  • Re: Add numbers within a cell


    Hi,


    See if this can help your temporary ... believe there should be a simpler method.


    =IF(LEN(B8)>2,(LEFT(B8-ROUNDDOWN(B8,-2))+RIGHT(B8-ROUNDDOWN(B8,-2))+LEFT(B8)),(LEFT(B8)+RIGHT(B8)))


    Cheers.

  • Re: Add numbers within a cell


    thanks Kieran. Bob's page was solved my problem so easily...and gave me some more ideas as well :)
    thanks once again.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!