Discussions

Expand all | Collapse all

Logarithm formula in QB

  • 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.

    In case anyone here has a deeper interest in the math behind this, you can read more about this principle here.​

    ------------------------------
    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
    ------------------------------