# Discussions

View Only

## Logarithm formula in QB #### George Bramhall11 days ago #### Brian Cafferelli10 days ago • #### 1.  Logarithm formula in QB

Posted 11 days ago
who remembers 6th grade math that can help me write this formula that works in an Excel spreadsheet but using a Numeric formula field in Quick Base:
=LOG(x,y)

------------------------------
George Bramhall
------------------------------

• #### 2.  RE: Logarithm formula in QB

Posted 10 days ago
Hi George, you can use the change of base formula to do this, which says dividing the natural log of a number by the natural log of the base you want to use, will give you the logarithm in the given number base. Quickbase's formula language is optimized for simple business math, but you can use our Ln() formula function to accomplish this.

For example, assume you want to calculate the logarithm of a number M in base b, and you have numeric fields set up for both M and b. You can set up a numeric formula like this:

`Ln([M]) / Ln([b])`

Likely you are working with base 10 (decimal) numbers, in which case you can simplify to this:

`Ln([M]) / Ln(10)`

A few things to keep in mind using this:
1. If you are using the result of this formula in other calculations, do not round this number. Instead, round at the very last step in your sequence of calculations.
2. Likely the result will be a long decimal value. Quickbase can give you an accurate log up to 10-12 decimal places, after which it will be rounded.

------------------------------
Brian Cafferelli
Product Marketing Manager | Quick Base
------------------------------

• #### 3.  RE: Logarithm formula in QB

Posted 10 days ago
Thx Brain, I did know we had a Ln Function.  (You must have gone past grade 6 in math.)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------