Unsure of How to write this equation

[Shiro23]

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

 

[cyrilbrd]

Hi, just curious, does (C*D(also D-1, etc)) mean 30*1 + 30*2 + 30*3 ect?

 

[Shiro23]

Hi, just curious, does (C*D(also D-1, etc)) mean 30*1 + 30*2 + 30*3 ect?

Yes, basically. As long as it gets the original D, as well as the (D-1)*30+(D-2)*30 down to D=1(which would become 0 i suppose lol) :3

 

[cyrilbrd]

so given C1 is 30 and D1 is 3 would be result be 180?

 

[Shiro23]

so given C1 is 30 and D1 is 3 would be result be 180?

Correct.

 

[cyrilbrd]

What is maximum value in D1?

 

[Shiro23]

What is maximum value in D1?

Well technically 255. But it is only rarely going to be above 100.

 

[cyrilbrd]

Well I have a solution but it is not elegant, still looking for a better approach.

 

[Shiro23]

Mmmk I'm willing to try what you have, but if you think that you know of a better way I'd like to see both :3