Equation with a defined number of decimals in the answer

Hi,

Use the Solver add-in. If you are using Excel 2003, here's how to install it (it comes with Excel, just not pre-installed): http://office.microsoft.com/en-au/ex...001127725.aspx

Take a look at this workbook, and look at the formulas that I have used (especially in the bottom section), and then look at the parameters that I have given to Solver to solve the equation.

I hope this helps

Thank you for both the answers.

Howerver, what I look for is a number that I can multiply with that gives exactly 4 decimals (or less). Not a rounded number.

Any suggestions?

Nicolai

haha it is in connection with a capital increase in a company. A billion is slightly to much

Thank you for both the answers.

Howerver, what I look for is a number that I can multiply with that gives exactly 4 decimals(or less). Not a rounded number.

Any suggestions?

Nicolai

Cell A1 will give you that answer after you have applied solver

Ajryan88, the solver add-in is superb!

Is it also possible to define the range the x should be in? For instance between 0,25 and 0,35. Still with only four decimals.

@shg: very acute observation!

Yeah it is pretty good sometimes

It sure is...

Thank you so much

You're welcome!

Please don't forget to mark this thread as solved, and please click on the * next to my post to say thanks