answersLogoWhite

0

If you want to know the logarithm of each individual number, type =LOG(A1), or whatever the first cell happens to be, for the first cell in the column of numbers, and then copy this cell downwards; Excel will automatically change the cell number to be relevant.

If you want to know the logarithm of the sum of all numbers in a column, type =SUM(A1:A5), or the relevant ends of your range, in an empty cell and then =LOG(B6), or whatever the label of that cell was.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Which direction do the contents shift when you add a new column in Excel?

to the right I had to take a class about excel and all of it shifted to the right when i added a new column


Why do they call a column a cell in Microsoft Excel?

A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.


How do you take the logarithm of a matrix?

You take the logarithm of each term.


What is Marco in Microsoft Excel?

A macro is a more complicated form of coding than a formula. Formulas enable you to add two columns of number into a third column. Macros will take the third column of numbers and update a diagram, save the results and print the diagram for you


What happens to units when you take the logarithm of a quantity?

When you take the logarithm of a quantity, the units of the quantity are removed.


If you have a column of values on excel wth negative and positive values and you want to take the LOG of them what do you do?

You can't take the log of negative numbers - at least, not while you stay in the realm of real numbers.You can't take the log of negative numbers - at least, not while you stay in the realm of real numbers.You can't take the log of negative numbers - at least, not while you stay in the realm of real numbers.You can't take the log of negative numbers - at least, not while you stay in the realm of real numbers.


How do you find the square root of 500?

Take the logarithm of 500, half it, then take the antilog.


How do you find the square root of 95249?

Take its logarithm, divide that by 2 and take the antilog of your answer....


How do you find out cubic roots?

Take the logarithm of your number, divide it by 3 then take the antilog.


Does the CONCATENATE function in Excel require a text argument?

Normally yes, but it will actually take numbers and combine them into a text string.


What is a number for which a given logarithm stands?

A number for which a given logarithm stands is the result that the logarithm function yields when applied to a specific base and value. For example, in the equation log(base 2) 8 = 3, the number for which the logarithm stands is 8.


How do you take anti log?

To take the antilogarithm of a number, you raise the base of the logarithm to the power of that number. For example, if you have a logarithm with base 10 and you want to find the antilog of ( x ), you would calculate ( 10^x ). Similarly, for a natural logarithm (base ( e )), you would compute ( e^x ). This process effectively reverses the logarithmic operation, yielding the original value before the logarithm was applied.