Excell project is giving me a hard time

[lataurusbryant8383]

Hello everyone
I have an excell project to do but having hard time. A friend of mine recommended this forum saying there are excell magicians here so I am asking for help
I have 15 numbers for example 111122223333444. I need to add a certain number ABCD to that number for ex 4433. so i created a cell with ABCD number and than add it to that number. 111122223333444 + 4433=111122223337877
Simple but my next step is giving me hard time.
so if the last number that is 7 now goes over 10(including 10) when i add 4433 than i need to add different number ABCE for ex4435 instead of 4433. if i add 4433 last number will go over 10 so i need to add 4435. so my next number in the column should be 111122223337877+4435=111122223342312
next number should add 4433 since last number +3 will not go over or equal to 10 (2+3) In the example i said last number but practically I can use last 2 numbers so if last 2 numbers go in next 10th than need to add the second number(for example 77 goes 80 and over , 88 goes 90 and over , 91 goes over 100,25 goes 30 and over)
so i need to create a formula to check this 2 conditions and to add the certain number to my number
add number ABCD (4433) to the initial number and if the last 2 numbers dont go over next 10th than this is the number in the cell if it goes over than add ABCE (4435) and the result is in the cell
this should be one formula to check conditions in each sell to add the appropriate number to that cell.
ABCD and ABCE should be in as separate cells so they can be changed to different numbers.
I know some of you will laugh at this but it is giving me hard time to find the correct function or functions to use.
I appreciate any help or suggestions. Thank you

 

[oldbrewer]

so if the last number that is 7 now goes over 10(including 10) when i add 4433

what does this mean - maybe if last number becomes less than or equal to original last number so if you added 4430 or 4431 or 4432 then that is fine otherwise add another number

 

[oldbrewer]

12345	12390				47	45
	formula
	=IF(RIGHT(A1+F1,1)<=RIGHT(A1,1),A1+G1,A1+F1)

<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[lataurusbryant8383]

this means if i add the 4433 to 111122223337877 last number will go over 10 or last 2 numbers will go from 77 to 110 so i need to add diff number 4435

so if the last number that is 7 now goes over 10(including 10) when i add 4433

what does this mean - maybe if last number becomes less than or equal to original last number so if you added 4430 or 4431 or 4432 then that is fine otherwise add another number. I think the function RIGHT you used will probably make the trick just need to figure the formula to make it the way i want. thanks

 

[oldbrewer]

if the last digit of the number you add flips the original last number to zero or any number up to one below the oroiginal last number then you use plan B - otherwise let the addition stand as it is...