quick xl help quezzie

  reddwarfcrew 17:28 03 Dec 2003
Locked

I should know the answer, but can't think!

I have:

a1 x a2^a3 = a4

now how would I write the formula if a4 is known and a2 is the variable (ie what is the opposite of ^).

(I know I can use goalseek).

cheers.

  spargo 10:17 04 Dec 2003

A3=[log(A4/A1)]/logA2

A2=antilog{(log(A4/A1))/A3}

where log =log to base 10

  spargo 13:51 04 Dec 2003

Prob. easier to use Nat Logs

A2=EXP(LN(A4/A1)/A3

  spargo 13:54 04 Dec 2003

Sorry try

A2=EXP(LN(A4/A1)/A3)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone