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?

If you need any more info, please let me know.

Cheers,

E