cancel
Showing results for 
Search instead for 
Did you mean: 

spreadsheet question

Community Veteran
Posts: 3,826
Thanks: 44
Fixes: 1
Registered: 24-09-2008

spreadsheet question

I've a number (say 5.61678e-21) we will call A, another number B (say 0.0014)
If A = Bn what function do I use to find n
Having a senior moment...................
5 REPLIES
Community Veteran
Posts: 6,735
Thanks: 12
Registered: 02-02-2008

Re: spreadsheet question

2 questions back at you:
1. Is n integer or something else?
2. What spreadsheet are you using?
It will probably be some sort of exponent function.
Community Veteran
Posts: 2,568
Thanks: 176
Fixes: 2
Registered: 27-05-2011

Re: spreadsheet question

I think it will be a log function  Smiley
To do is to be - Neitzsche
To be is to do - Kant
do be do be do - Sinatra
pwatson
Rising Star
Posts: 2,468
Thanks: 8
Fixes: 1
Registered: 26-11-2012

Re: spreadsheet question

Mathematically
n=LogBA
In Excel the function LOG takes parameters Number and Base so =LOG(Cell 'A', Cell 'B') should work
PeeGee
Aspiring Pro
Posts: 1,098
Thanks: 51
Fixes: 3
Registered: 05-04-2009

Re: spreadsheet question

try:
=log10(A)/log10(B)
or
=ln(A)/ln(B)
(the answer is the same  ~ 7.0958 for the given A and B !!!!)
Phil
(lapsed CMath)
Plusnet Fibre (Sep 2014), Essentials (Feb 2013); ADSL (Apr 2009); Customer since Jan 2004 (on 28kb dial-up)
Using a TP-Link TD-W9980 modem-router.
Community Veteran
Posts: 3,826
Thanks: 44
Fixes: 1
Registered: 24-09-2008

Re: spreadsheet question

doh, ...................comes back to me now, Thanks guys - drinks on me - works a treat, (am using excel, n is not an integer).