Formula with 2 variables and 2 fixed values

[amenasce]

Hi All, i am a total newbie with Excel but i need to create a formula that will allow me to project a revenue stream with the following information :




(a*999)+(b*50) and i need to have A and B grow +20 every month. How would i do that?

Thanks in advance!

[ZERKproject]

check attached

[MarvinP]

Hi amenasce and welcome to the forum.

We really need an example of your data to give a good answer. If you click on "Go Advanced" below the message area and then on the Paper Clip Icon above the message area you can attach a sample file.

I'm thinking a Dynamic Named Range may solve you problem but can't be sure without seeing more of it.
See if http://www.ozgrid.com/Excel/DynamicRanges.htm helps

[amenasce]

Im sorry i explained it wrong!

Basically, at T0 we start with a fixed number (30).

So it starts with 30*999+30*50. However, the 999 is a one time fee, and the 50 is a monthly fee. We increase the number of customer by 20 each month, each paying the one time fee of 999 and the monthly fee of 50.

so T0 would be : (30*999)+(30*50)
T1 would be : (20*999)+(50*50)
T2 would be : (20*999)+(70*50)

Etc..

Does this help?

Thanks !

Andrew

[MarvinP]

Hi,

I really need a sample file attached to make heads or tails from your discription..

[amenasce]

Hi,

I really need a sample file attached to make heads or tails from your discription..

I havent started a file yet. Im not sure if the attached would help. Thanks for your help.

[MarvinP]

I'm still a little clueless but find the attached and see if it is what you want.

Hope this helps!

[amenasce]

I'm still a little clueless but find the attached and see if it is what you want.

Hope this helps!

The formula helps but the elements are not correct.
I updated it but i still dont know how to implement the fact that every month we would be adding 20 different customers paying the $50 fee.

See the attached.

thanks !

[MarvinP]

Look at the formulas in column C in:

[amenasce]

Look at the formulas in column C in:

Great !! Thank you !