Subtracting data from a cell when it is a multiple of what needs to be subtracted

[Lifes0wn]

Good Day all

This is my first post and i am not an "excel engineer" , please bare with me.

Essentially i have a row of cells that needs to be identified if it is larger than a certain amount (x for example )
and then X subtracted from it as many times needed to get it below x.

I then need to add the amount of times i subtracted x to be added to another cell.

I am not sure if this seems to be a junior topic and dont want to irate people but you all look so helpful .

Thanks in advance

 

[bewsh1987]

Good morning I have sent you the working so far to you email address

if it work let me know

 

[bschwartz]

Is this question resolved? I can see there is some PMing going on here. For general practice, we try to stay away from answering by PM because than no one else with the same question can benefit from the responses.

 

[Lifes0wn]

Hi bschwartz ,

I merely "pm'ed" the same documents that i posted here before i did post it here so that someone else could work on it instead of summize what i am talking about.

As soon as i get a solution that is not posted here or relevant information i will make sure it is posted on this thread.

As of yet i am still struggling with the solution.

 

[konew1]

Maybe

I deduct 25 from weekly savings and 2 rows down add one to number of coupons. Then I increase value of coupons because I assume when 12 changes to 13 the value changes from 300 to 325. Meanwhile the weekly savings remaining after taking out 25 is carried to next line.

Note the first 2 rows have non standard formula in yellow cells. You can copy the third row down as far as needed

Excel Workbook
	E	F	G	H
3	Weeks	No Coupons	Coupon Value	Weekly savings
4	1	12	300	1.76
5	2	12	300	1.76
6	3	13	325	3.99
7	4	14	350	6.22
8	5	15	375	8.45
9	6	16	400	10.68
10	7	17	425	12.91
11	8	18	450	15.14
12	9	19	475	17.37
13	10	20	500	19.6
14	11	21	525	21.83
Sheet11

EDIT: My calc must be wrong. If you can double your money by week 14 can I buy into the scheme?

 

[Lifes0wn]

That looks really promising promising.

I think there is some missing information ( like that the coupons expire after 16 weeks and also that some of the weekly savings come to a toal of more than 50 and 2 coupons need to be added to cells down in the relevant column,but im sure these are minor fixes )

Ill post a recent work done on the spreadsheet with notes to help explain what i mean and what the values should look like with a certain initial investment.

I manually calculated the values so they are correct up till row 25.

https://www.dropbox.com/s/q9jiucr84opb20l/euro 25 investment re-edited.xlsx?dl=0

 

[Lifes0wn]

My deepest apologies,

I have been informed some calculation were incorrect.I have checked and checked and re-calculated.

Anyone that has been working on the SS here is the correct and updated version.

https://www.dropbox.com/s/g24azjwz6wxy928/euro 25 investment re-edited V1.2.xlsx?dl=0

 

[konew1]

Please post details and sections of your spread sheets on this message board. You will get more help if the entire thread is in one place, and some of us prefer not to download unknown files.
See 'recommended Addins on this link to see how to post sections of spread sheets in your message. http://www.mrexcel.com/forum/excel-questions/628649-recommended-add-ins-links.html

 

[Lifes0wn]

Thanks for the advice konew1, i will more than likely put in place what ou just mention when i actually figure out what you said. Unfortunately im dafter than Daft-Punk so at this moment ... No idea.

So i understand there is an issue with the download and that makes sense completely but this problem has been resolved by my good friend bewsh1987 and supplied me with a product i can complete further.

If you really want to know the solution you may download the Virus FREE excel file from my shared dropbox link and enjoy the same satisfaction i did with the result and if you scared which is ok no worries im sure the agony of the answer within your grasp will subside in a few yeas XD

Thanks to all that helped
I appreciate it.

Solved Excel file https://www.dropbox.com/s/ikx8jy7afjxos54/euro 25 investment.xlsx?dl=0

 

[konew1]

Thanks for the advice konew1, i will more than likely put in place what ou just mention when i actually figure out what you said. Unfortunately im dafter than Daft-Punk so at this moment ... No idea.

So i understand there is an issue with the download and that makes sense completely but this problem has been resolved by my good friend bewsh1987 and supplied me with a product i can complete further.

If you really want to know the solution you may download the Virus FREE excel file from my shared dropbox link and enjoy the same satisfaction i did with the result and if you scared which is ok no worries im sure the agony of the answer within your grasp will subside in a few yeas XD

Thanks to all that helped
I appreciate it.

Solved Excel file https://www.dropbox.com/s/ikx8jy7afjxos54/euro 25 investment.xlsx?dl=0

Sweet-as.
I agree with some of your comments, and am glad you have found a solution to the problem you listed.