using excel to solve complex equations

[azamc]

how do i solve the following equation in excel for given values of d?

d=[(88.6×10^(-9) )(((4c-1)/(4c-4))+(0.615/c))]^(1/3)

thanks

 

[gumbald]

d = 42

 

[muon]

Why not download proper maths software?

 

[gumbald]

It can be done in Excel, just build it up using the brackets. Or work out each part in a cell and combine.

 

[Kreeeee]

Rearrange it manually to make c=... then wherever d is replace it by a cell reference and put your desired d value in there.

 

[azamc]

Rearrange it manually to make c=... then wherever d is replace it by a cell reference and put your desired d value in there.

it is very hard to rearange in terms of c

 

[azamc]

Why not download proper maths software?

such as?

 

[azamc]

It can be done in Excel, just build it up using the brackets. Or work out each part in a cell and combine.

im still clueless....

 

[muon]

such as?

Well my university, doesn't really teach much maths but uses maple.

http://www.maplesoft.com/

Of course none of the software will be free.

 

[Cr0fty]

d = 42

I see what you did there

 

[GingerNinja1989]

such as?

Maple

Edit: noticed someone else had reccomended it. Jolly good show!

 

[Cobertizo]

Go to Tools->Add-ins, then select the "Solver Add-in". In A1, put the right hand side of your equation (but replacing 'c' with a ref to B1). In B1, put a value. Then go to Tools->Solver... Your target cell is A1. Choose the "value of" radio button, and bung your d value in the box. For "by changing cells", choose B1. Then hit Solve. The value in B1 is your answer.

 

[dave-lew99]

Just use Octave.

http://www.gnu.org/software/octave/

Like MATLAB, but free.

 

[Namsnik]

As Cobertizo said
Or just use tools, goal-seek in a similar way.