I'd like to know what kind of formula/what is the formula to have Excel figure something like this out:
Say
A=7
B=12
C=30
D=Scaling(1-100) Like a unit's level
And it will make Q=((A*B*C)+(C*D(also D-1, etc)) like an Arithmetic progression. Where D is Q/((A*B*C)+(C*D(also D-1, etc))
So for the second half of the problems, I want it to also include every number of D down to 1, so like D-1, D-2, D-3, etc until it hits 1, but still all multiplied to the C, and added to the (A*B*C).
If I have a number for X like say 20000. I want to get Q=(A*B*C)+(C*D(also the D-1, etc) where Q is how many times (A*B*C)+(C*D(also the D-1, etc) will fit into the 20000, and any leftover perhaps placed into another column while also showing me where (A*B*C)+(C*D(also the D-1, etc) is at down the line, so at 20000, I believe it comes out to D=7, and (A*B*C)+(C*D(also the D-1, etc) Q becomes 3360(If I'm doing my math right). But I don't know how to get it to work that way in Excel. Nor am I sure of how to have Excel give me the answers in different locations in my spreadsheet, like D in B4 and Q in B4.(does not literally have to be those positions, just examples)
I can do this problem in my head, but considering it has to be done many times, once I get into bigger numbers like x=40000, I don't want to have to go by hand and do it every time. So I would greatly appreciate it if someone could help me! :D
Say
A=7
B=12
C=30
D=Scaling(1-100) Like a unit's level
And it will make Q=((A*B*C)+(C*D(also D-1, etc)) like an Arithmetic progression. Where D is Q/((A*B*C)+(C*D(also D-1, etc))
So for the second half of the problems, I want it to also include every number of D down to 1, so like D-1, D-2, D-3, etc until it hits 1, but still all multiplied to the C, and added to the (A*B*C).
If I have a number for X like say 20000. I want to get Q=(A*B*C)+(C*D(also the D-1, etc) where Q is how many times (A*B*C)+(C*D(also the D-1, etc) will fit into the 20000, and any leftover perhaps placed into another column while also showing me where (A*B*C)+(C*D(also the D-1, etc) is at down the line, so at 20000, I believe it comes out to D=7, and (A*B*C)+(C*D(also the D-1, etc) Q becomes 3360(If I'm doing my math right). But I don't know how to get it to work that way in Excel. Nor am I sure of how to have Excel give me the answers in different locations in my spreadsheet, like D in B4 and Q in B4.(does not literally have to be those positions, just examples)
I can do this problem in my head, but considering it has to be done many times, once I get into bigger numbers like x=40000, I don't want to have to go by hand and do it every time. So I would greatly appreciate it if someone could help me! :D