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

16y 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.


Can you take the log of an imaginary number?

Yes, you can take the logarithm of an imaginary number, but it's more complex than with real numbers. The logarithm of a complex number, including imaginary numbers, is defined using the polar form of the number. For an imaginary number like ( bi ) (where ( b ) is real), the logarithm can be expressed as ( \ln|b| + i\arg(b) ), where ( \arg(b) ) is the argument (angle) of the complex number in the complex plane. Thus, the result will also be a complex number.


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.

Trending Questions
You're troubleshooting a problem with poor performance over a WAN connections at your office Looking at the smart jack you see the Tx light is blinking green and the Rx light is not illuminated? What is difference between a raster and a vector display unit? Where can one get personalised photo placemats from online? How do you see folder content and not a preview in mac? Write a short note on primary memory? How is it possible for a network to uphold a maximum speed? What does the process of laser ablation entail? What type of browsers allow you to open multiple web pages at one time? List of all input output and support hardware devices you encounter in your daily life? What type of control is provided by the first processing step of receiving the records as previously describrd? How do you change the icon picture after you logout on a mac laptop? Little animals with long tails? When trying to play Candy Crush on my mac os x 10.5.8 it won't load. Im assuming my adobe flash player needs to be updated and that is why it isn't working. I went to update the flash player and it sa? Which utility is used to add printer drives to the printer driver store? During eor actions after an attack you locate two uxo items approximately three inches in diameter within 50 feet of the partially sandbagged hospital tents the patients cannot be evacuated from the? What are types of graphics in multimedia? Are meerkats heterotroph or autotroph? What is the full form of PDA? What is flat screen panel display device? What are the names of the two power connectors used on the AT motherboard form factors?