Archive of the former Yahoo!Groups mailing list: MOTM

previous by date index next by date
  topic list  

Subject: RE: [motm] Excel Question (only slightly off-topic)

From: "Tkacs, Ken" <ken.tkacs@...>
Date: 2000-04-19

Aha! Thanks!

I'm working on a spreadsheet (obviously); I'll post a link to it when I get
back to it... others may find it useful.



-----Original Message-----
From: Aardvark1@... [mailto:Aardvark1@...]
Sent:Tuesday, 18 April, 2000 6:29 PM
To:motm@egroups.com
Subject:Re: [motm] Excel Question (only slightly off-topic)

Finally a question I can answer!!!

=POWER(2∗B4,1/12)
(I'm assuming "two' of the cell above it" means 2 times the cell above
it...)

If this equation is in cell B5 then B4 represents the cell above it!!!

Power(a,b) is the excel funtion that raises a to the b power... Power(2,3)
would return 8, Power(2,4) would return 16...

To get the root of a number you would invert b and write it as
Power(a,1/b)... Power(16,4) would return 2... 2 is the 4th root of 16...

If you wanted the root of 2 of 'a' you would write the equation
Power(2∗a/1/b)

Okay, I'm boring myself!!!

Go ahead and plug numbers in the attached little excel speadsheet and have
fun...

If it's not quite what you're after go ahead send the equation and I'll be
more than happy to work it out for you!!!

Good Luck...
Al (failed all my english classes) Wagner



------------------------------------------------------------------------
Get a FREE Virgin backpack-style Bag with EVERY order!
http://click.egroups.com/1/3000/3/_/529958/_/956096939/
------------------------------------------------------------------------