Now, I would like to create similar calculators with other functions, for example,

60/12=5

or

1000*80%*50%*(600/300)=800

How do I set up the formula, or where do I find help learning about how to do this?

Thank you,

Katarina

You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

- Thread starter katarinah
- Start date

Now, I would like to create similar calculators with other functions, for example,

60/12=5

or

1000*80%*50%*(600/300)=800

How do I set up the formula, or where do I find help learning about how to do this?

Thank you,

Katarina

You will need a number of scroll bars for each of your parameters

in your examples 2 and 5 respectively

Each Scroll bar needs to have a Minimum, Maximum and a cell link set

Lets assume you link them to N1 & N2 and N1, N2, N3, N4 & N5 respectively

then your 2 formulas will be

=N1/N2

=N1*N2*N3*(N4/N5) make sure N2&N3 are formatted as %

If you are searching for a slider to control the answer and work backwards, that can be done, but you need to redfine the problem and then which variable would you want to vary.

Or you can apply Goal Seek to your model (Date, What If Analysis, Goal Seek)