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

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)