Solver equation solving

Discuss the spreadsheet application
Post Reply
kovacsak
Posts: 1
Joined: Thu Mar 05, 2015 9:24 pm

Solver equation solving

Post by kovacsak »

I try to solve equation above use of Solver:
=B4*(B1+B5)*EXP(-B1*8*B4)
I have typed values of B4, B5 - these are a and b parameters - and after that using Solver.
OpenOffice 3.1 on Windows 8.1
User avatar
Lupp
Volunteer
Posts: 3553
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Solver equation solving

Post by Lupp »

How to solve an equation with only one side?
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Solver equation solving

Post by acknak »

kovacsak wrote:I try to solve equation above use of Solver:
Ok, so what happened?
=B4*(B1+B5)*EXP(-B1*8*B4)

I have typed values of B4, B5 - these are a and b parameters - and after that using Solver.
I seem to recall that the parameters need to be independent. Yet both B1 and B4 are involved in both parameters.

This seems suspicious to me but I don't understand well enough to say for sure.
AOO4/LO5 • Linux • Fedora 23
Post Reply