LOG

Returns the the logarithm of a number given a base. Learn more

Video field
Math

LOG is a function in Google Sheets that returns the logarithm of a given number to a specified base. If the base is not specified, the function returns the logarithm of the given number to the base 10.

The function takes one or two arguments:

value: the number whose logarithm you want to calculate. base (optional): the base of the logarithm. If this argument is not specified, the function assumes a base of 10. The syntax for using the LOG function in Google Sheets is:

=LOG(value, [base])

For example, if you want to find the logarithm base 2 of the number 8, you can use the LOG function in Google Sheets as follows:

=LOG(8, 2)

The result would be 3, which is the logarithm base 2 of 8.

If you want to find the logarithm to a different base, you can specify the base as the second argument. For example, if you want to find the logarithm base 5 of the number 125, you can use the LOG function in Google Sheets as follows:

=LOG(125, 5)

The result would be 3, which is the logarithm base 5 of 125.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!