cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
armindalwix
Community Member

Log formula question with negative exponents

I cannot figure out how to write a formula question for the following:

1. -log(2.35 x 10-12)=    with -12 being an exponent.  The answer would be 11.63

The variable [x] could be the coefficient 2.35, the exponent, or the entire number.  The minimum and maximum variables are all very small numbers (way less than one).

2.  10(-x)  this is meant to be 10 raised to power of negative x.  X is the variable within the range of 0 and 14.

Can anyone help?

0 Kudos
1 Reply
karenchaffee
Community Member

abs(log(a*10^-b))

a is 1 through 9 with three places past decimal

b is 1 through 13 with zero places past decimal

 

Try this and see if it works for you