cancel
Showing results for 
Search instead for 
Did you mean: 

spreadsheet question

Community Veteran
Posts: 3,827
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: 177
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,106
Thanks: 56
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 Archer VR600 modem-router.
Community Veteran
Posts: 3,827
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).