Can't work out how to find the formula behind a page

[Cigarsam]

Hi there,

I've been having some problems with an excel page whereby I need to know the underlying formula used but can't actually click or edit any of the cells other than 3.

The page is designed for you to enter three variables which are then used to calculate a transport rate, I need to know how they calculated the transport rate but I can't click on any of the cells other than the 3 that they let me (so can't see the formula used).

Here is a picture of the page http://puu.sh/7tLbZ.png


Thank you very much for your help,
it really is very important to me!

Thanks,

Sam

[Fotis1991]

Probably the sheet is protected and hide formulas option is ticked!

OR

Use vba and not formulas.

[Cigarsam]

Hey thanks for the response - after two days of trying to work it out I just did moments after posting this! I worked out that the for cell k,15 is
=IF(K13<K14,0,$I7/($I7-$I9)*0.1*((K13-K14)/5)^1.5*(K5/0.1)^-0.67*($I8/0.0011)^-0.5*K6)

however I have no idea how to translate this to an english formula!

[Tony Valko]

Maybe a long shot but at least it's a shot!

http://j-walk.com/ss/excel/tips/tip37.htm

[Cigarsam]

Wow thanks -

I'm a bit of an excel virgin but i'll give it a go!

[Cigarsam]

Got it working now, thanks for that - http://puu.sh/7tPEv.png

Still.. not sure how to change it into a formula that I can use with paper and a pen using all the variables.

Not sure how to translate IF's and $'s into real life formula.

Any ideas?

[Tony Valko]

A few of those formulas have a lot of "moving parts" (this times that to the power of this times this to the power of that divided by this...)

Is there a particular formula you don't understand?

For an explanation of the dollar sign $, see if this helps:

About cell and range references

http://office.microsoft.com/en-us/ex...005198323.aspx

[Cigarsam]

Well

I have the formula

=IF(L13<L14,0,$I7/($I7-$I9)*0.1*((L13-L14)/5)^1.5*(L5/0.1)^-0.67*($I8/0.0011)^-0.5*L6)

Which using variables translates to -

Transport Rate =IF(Power<CriticalPower,0,$DensityS/(DensityS-DensityW)*0.1*((Power-CriticalPower)/5)^1.5*(Width/0.1)^-0.67*($Grainsize/0.0011)^-0.5*DensityS)

I need an equation whereby transport rate = these variables in some way without the IF and 0, and $

Problem is I have no idea how to do this, it's too confusing to a noob like me!

Help would be greatly appreciated!

[Tony Valko]

Transport Rate =IF(Power<CriticalPower,0,$DensityS/(DensityS-DensityW)*0.1*((Power-CriticalPower)/5)^1.5*(Width/0.1)^-0.67*($Grainsize/0.0011)^-0.5*DensityS)

I need an equation whereby transport rate = these variables in some way without the IF and 0, and $

Will Excel accept that formula as written?

The $ sign in that syntax is an illegal character.