Adding 5 numbers to a single 3 digit

**wd8ekd** · 07-26-2008, 07:34 AM

Got one almost like the other one but different---

07--26--08
We need help from you experts again in excel....

Question ---What is the Formula in excel for adding
five numbers to a single 3 digit number and also
when you add to the 3 digit number you do not carry
over????
Example:
NO.-----+5
678-----123
901-----456
889-----334
All numbers are together in one row..
Can someone please give me the formula.....
Thank you so much
Bob in Michigan

**Gearcutter** · 07-26-2008, 10:14 AM

Hi,
Working on the same premis as the last thread try;
=RIGHT(INT(A2/100)+$B$1)&RIGHT(INT(A2/10)+$B$1)&RIGHT(RIGHT(A2,3)+$B$1)
This assumes that the number is in A2 and the number to + is in B1
hope this helps
regards Howard

**Ron Coderre** · 07-26-2008, 11:04 AM

With
A1: (blank)
B1: 5
and
A2: 678
A3: 901
A4: 889

This formula adds the value in B1 to each digit in the Col_A cell
and concatenates only the digit's from those values:

Please Login or Register  to view this content.

Copy that formula down through B4

In the above exampe, these values are returned:
B2: 123
B3: 456
B4: 334

Is that something you can work with?
Post back if you have more questions.

**wd8ekd** · 07-26-2008, 11:50 AM

formula does not work---

row to add 5 digits to is row c and the numbers will go into row D
answer goes into row D
I want to add 5 to each number 5+6=1--7+5=2--8+5=3--nocarry over
in adding each number----hope I explained it right---
answer is 123 in row D

C-2-3-4-row-----D-2-3-4-row
678----------------------123answer
901----------------------456answer
889----------------------334answer

thank you
Bob in Michigan

**Ron Coderre** · 07-26-2008, 12:02 PM

Well, the formula can easily be adjusted to
accommodate the different locations of the values...

With
D1: 5
C2: 678
C3: 901
C4: 889

Then....

Please Login or Register  to view this content.

Copy that formula down through D4

The returned values will be:
D2: 123
D3: 456
D4: 334

**olasa** · 07-26-2008, 12:37 PM

Here is yet another option (see encl. file)

=SUMPRODUCT(RIGHT($B$1+MID(A3,{1,2,3},1),1)*{100,10,1})

I found that all 3 solutions give the result you are looking for.

I could just mention one thing. If the added number is negative, the two first formulas give a different result. I don't know if this is important and in such case what rule you prefer.

Add: -1
Result:
3. 2. 1.
567 567 567
810 890 890
778 778 778

Hope this could be of use
Ola