ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Drivers for percentage increase (https://www.excelbanter.com/excel-worksheet-functions/253041-drivers-percentage-increase.html)

Jo

Drivers for percentage increase
 
I am trying to set up a driver to include in my budget profile so that my
managers can select the percentage from a driver and see on each budget line
what the outcome will be i.e
staff costs may be calculated at 150,000 but if I used my driver to
calculate an increase of 3.5% that would change the staff costs to 155,250.

Can anyone help?
Regards
Jo

trip_to_tokyo[_3_]

Drivers for percentage increase
 
I am not sure what you question is but this may help:-

In cell A 2 I have 150,000

In cell B 2 I have 3.5%

In cell C 2 I have:-

=(A2*B2)+A2

- and this returns 155,250 to cell C 2.

If my comments have helped please hit Yes.

Thanks.


"Jo" wrote:

I am trying to set up a driver to include in my budget profile so that my
managers can select the percentage from a driver and see on each budget line
what the outcome will be i.e
staff costs may be calculated at 150,000 but if I used my driver to
calculate an increase of 3.5% that would change the staff costs to 155,250.

Can anyone help?
Regards
Jo



All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com