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

 

[bschwartz]

I'm afraid that is still circular, since F informs H which informs F. Can you please explain in words WHY this is the case? Why does that amount get added to column F, two rows down?

 

[Lifes0wn]

thats correct but it will only add the 7 2 cells below whereit would of said 80

so technically with those figures column F should look like this

64
something
80
something
87

not sure what the other figures should be but i can work it out if need be
its killing me s i have the brain to do the calculations but the problem is do do 1000 lines of it is insane
also every initial investment creates a new set of possibilities
therefore i need to create a spreadsheet for it ... but alas i am not that skilled yet.

 

[Lifes0wn]

ok basically its a cascading effect not a direct change to a cell that affect the cell that was initially affecting the affected cell. ( im getting confused myself )

Lets say this "coupon" provides a fixed value of 35.68 every 16 cells but pushes that out in small amounts of 2.23 every cell

once that 16 cells are completed that "coupon" expires but while this coupon is providing a value of 2.23 every cell when it accumulates 25 or more you can aquire another "coupon".

the reason it is two cells down is that once you get the 25 only in the next cell does that coupon come into play therefore it requires another cell to create that 2,23 production.

so for the sake of the formula if it was put one cell down it would affect the one cell downs formula creating an error i believe as when you invest you do not get returns that day therefore i put it 2 cells down

The end result is to formulate at what rate the coupons can sustain itself with a certain withdrawal amount been taken out of it and what initial input is needed to get to that stage optimally

 

[Lifes0wn]

I am not helping am I...?


The way i see it it cant possibly be circular as no cells affect any cells that are affecting it.

i just cant figure out how to do 2 things to one cell from 2 different source cells

To be honest i am not even sure if i am being understood correctly not that its anyones fault but my own .

 

[bewsh1987]

I am really trying to understand however I feel more lost

sorry This could end up being something so simple

 

[Lifes0wn]

Thank you for trying tho

I cant ask more.

Maybe i get lucky and someone can understand my brain farts

Would it help if i share the doc itself and write comments in what is needed ?

 

[bewsh1987]

yes of course that may help

email me your document as I really want to help


please can you let me know hen you have got the address as I don't want to leave it on here

 

[Lifes0wn]

got it

 

[bschwartz]

I'm also finding this a bit confusing. An example might help. You can post your spreadsheet or an example spreadsheet with expected results on a file sharing site like dropbox.com and share the link here.

 

[Lifes0wn]

Good Morning,

I was just figuring out this morning how i was going about sharing that file , forgot i had DB already installed.

I am providing two files, first link is the file i am going to use in the end to complete my spreadsheet and the 2nd link is what the calculation are supposed to look like in the end with manual inputs but only done for a few lines. i have also colour coded where which cell affects other cells to an extent.

Please let me know if i can provide further information to help solve this problem.

https://www.dropbox.com/s/fkna9xqg7cw55z4/euro 25 investment ( Raw unedited ).xlsx?dl=0
https://www.dropbox.com/s/ykuphv3ds...t (Manual inputs ) how it should be.xlsx?dl=0