# Carrying over into adjacent cell

#### Eggplant2016

##### New Member
D1=5
D2=4
D3=9
D4=Sum(d1:d3)

But I want d4 instead of showing "18", I want D4 to show "8" and C4 to show the "1"...

But I want this formula for numbers as large as 1,000,000.00

So I have 9 individual cells from A:I across. And when ever the number is large enough I want it to "carry over" the tens.

So basically it will look as though the math was being done on paper.

Thanks

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### Gerald Higgins

##### Well-known Member
This might get you started . . .

In D4
=MOD(SUM(d1:d3),10)

In C4
=(MOD(SUM(D1:D3),100)-D4)/10

#### Eggplant2016

##### New Member
No...that question is asking how to separate a whole number into places in different cells.
I.e the sum of 4 cells is "1250.50" and having that number be put into 6 individual cells based on their number place.

This question is asking how to add numbers in a range of cells and have the number carry over to the cell on the left, just as if you were doing addition on a piece of paper.....

Not sure if you are confused, or if i didnt explain it properly.

Last edited by a moderator:

Replies
3
Views
400
Replies
7
Views
278
Replies
2
Views
150
Replies
2
Views
137
Replies
2
Views
718

1,195,939
Messages
6,012,420
Members
441,698
Latest member
DaveTeo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back