lataurusbryant8383
New Member
- Joined
- Aug 6, 2018
- Messages
- 2
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
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
