Excel - finding the power of 2 from a result? - diyAudio
Go Back   Home > Forums > General Interest > Everything Else

Everything Else Anything related to audio / video / electronics etc) BUT remember- we have many new forums where your thread may now fit! .... Parts, Equipment & Tools, Construction Tips, Software Tools......

Please consider donating to help us continue to serve you.

Ads on/off / Custom Title / More PMs / More album space / Advanced printing & mass image saving
Reply
 
Thread Tools Search this Thread
Old 12th July 2006, 12:39 PM   #1
AndrewT is offline AndrewT  Scotland
diyAudio Member
 
Join Date: Jul 2004
Location: Scottish Borders
Default Excel - finding the power of 2 from a result?

Hi,
I want to use Excel spreadsheet to calculate attenuation of a simple RC single pole filter.

I need a formula to give the power that 2 must be raised to when I already know the resultant of the power.
i.e.
2^X=32, then X=5
or
2^Y=47.1, then Y=?

I know that the answer that I need is Y=5.56 using a calculator but how can I get Excel to give me that answer?
__________________
regards Andrew T.
  Reply With Quote
Old 12th July 2006, 12:51 PM   #2
diyAudio Member
 
Join Date: Nov 2004
Location: UK, bristol
Y= log(47.1)/log(2)
  Reply With Quote
Old 12th July 2006, 01:05 PM   #3
AndrewT is offline AndrewT  Scotland
diyAudio Member
 
Join Date: Jul 2004
Location: Scottish Borders
Hi Jimbo,
thanks.

It works!
__________________
regards Andrew T.
  Reply With Quote

Reply


Hide this!Advertise here!
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding out the power an unknown speaker can handle NIC1138 Multi-Way 28 19th January 2009 02:17 AM
is a f3 enough to power seas 7" excel? vpolineni Pass Labs 1 15th December 2007 05:42 PM
finding pcb speaker /power (block)terminals? Clipped Car Audio 15 22nd September 2007 04:46 AM
Need help finding push button power switch to fit my amp Ken C Solid State 4 13th July 2004 12:42 AM


New To Site? Need Help?

All times are GMT. The time now is 01:23 PM.


vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Copyright 1999-2014 diyAudio

Content Relevant URLs by vBSEO 3.3.2