# Formula Help - 2 dynamic variables

#### eoinymc

##### Board Regular
Hi,

Just wondering if anyone can help me.

I'm currently trying to solve an equation and put it into an excel formula.

If I have the following info:
 Customers 10 Total Revenue \$200 Revenue Per Customer \$20

<tbody>
</tbody>

I want to increase my total revenue by \$100 and the increase will be gotten by 50% of revenue increase and 50% of customer increase.

Can anyone help me out on how to do this please?

Cheers,

E

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### eoinymc

##### Board Regular
I meant to say that I'm looking for a way to figure out what my new average revenue per customer is and what my new total customers are if I get the required increase by increasing both by 50%...

#### oldbrewer

##### Well-known Member
 customers 10 11 12 13 14 15 16 17 20 200 220 240 260 280 300 320 340 20.5 205 225.5 246 266.5 287 307.5 328 348.5 21 210 231 252 273 294 315 336 357 revenue per customer 21.5 215 236.5 258 279.5 301 322.5 344 365.5 22 220 242 264 286 308 330 352 374 22.5 225 247.5 270 292.5 315 337.5 360 382.5 23 230 253 276 299 322 345 368 391 23.5 235 258.5 282 305.5 329 352.5 376 399.5 24 240 264 288 312 336 360 384 408 24.5 245 269.5 294 318.5 343 367.5 392 416.5 25 250 275 300 325 350 375 400 425 25.5 255 280.5 306 331.5 357 382.5 408 433.5 26 260 286 312 338 364 390 416 442 26.5 265 291.5 318 344.5 371 397.5 424 450.5 27 270 297 324 351 378 405 432 459 27.5 275 302.5 330 357.5 385 412.5 440 467.5 28 280 308 336 364 392 420 448 476 28.5 285 313.5 342 370.5 399 427.5 456 484.5 29 290 319 348 377 406 435 464 493 29.5 295 324.5 354 383.5 413 442.5 472 501.5 30 300 330 360 390 420 450 480 510 clearly 13 customers and \$23 per customer is one solution as is 14 customers and \$21.5 per customer you have to decide what is possible

<colgroup><col><col><col span="12"></colgroup><tbody>
</tbody>

#### eoinymc

##### Board Regular
Thanks for the help..

It's not quite what I was looking for. I wanted a way to do this by being able to change the 50%/50% split in a cell and a formula automatically updating what would show what this meant for increase in customers and revenue.

But I appreciate that.

E

#### oldbrewer

##### Well-known Member

ok I did not "see" that in your original post - I will give it more thought...

#### eoinymc

##### Board Regular
ok I did not "see" that in your original post - I will give it more thought...

Thanks so much...it's hurting my head!

#### oldbrewer

##### Well-known Member

 10 customers custincr% percustincr% \$20 per customer 45 55 \$200 REVENUE customers 14 per cust 31.00 REVENUE \$434.00 now you can play with the % split to study the effect on total revenue if this is ok with you, I will post formulas

<tbody>
</tbody>

Last edited:

#### eoinymc

##### Board Regular
I don't think I'm explaining it correctly.

The target revenue to hit is \$300 (which is an increase of \$100). This is a constant.

How I get that extra \$100 is a mix of increasing customers and revenue per customer.

50% of the increase should come from increasing customers and 50% from increasing the revenue per customer. i.e. in this example, \$50 incremental revenue from increasing rev per customer and \$50 from increasing customers.

Then, what I want to be able to do is to change 50-50 to 60-40 or whatever and it shows me what the mix of increases will be.

Does that explain it?

Thanks again for your help thus far.

E

#### Noodleski

##### Active Member
12,5 customers is a bit weird, isn't it? I guess that's what oldbrewer tried to avoid.

#### oldbrewer

##### Well-known Member
if you get X more customers and Y more revenue you get an equation 20X +XY+10Y = 100

clearly there are infinite solutions.....my table shows you this and my post 7 gives you a way to look at the effects of varying the split percentages

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,194
Messages
5,835,914
Members
430,394
Latest member
Ace_Quared

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back