0
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?
Wiki User
∙ 14y ago
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.
Wiki User
∙ 14y ago
Wiki User
∙ 14y agoYou can't take the log of negative numbers - at least, not while you stay in the realm of real numbers.
Add your answer:
Earn +20 pts
What chart uses vertical rectangles to represent values in Excel?
A column chart.
What is the address of 255 column in Excel?
Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.Column 255 in Excel is column IU.
How do I sort formula based values in Excel?
Copy the formulas and in the column next to them, use the Paste Special option and choose values. It will put the actual values into the cells. You can then sort your data based on the column of values.
What chart to compares values side by side broken down by category on Excel?
A column chart.
How do you insert rows in Excel 2007 past IV?
Column IV is not the last column in Excel 2007, as it was in Excel 2003. In Excel 2003 the last column is IV which is column 256. In Excel 2007 the last column is XFD, which is column 16384.
In Excel a button that inserts Excel functions to sum average or count all the values in a column or row or display the minimum or maximum value in a column or row is called the?
The Autosum button can do all of those things.
In Microsoft Excel cell How do you change the negative sign to positive?
Multiply by -1
Is there an Excel spreadsheet formula to find offsetting positive and negative numbers in a column of data?
If you mean you want to find how far the numbers are from zero, whether they are positive or negative, you could use the ABS function. So if the first value was in A2, then in B2 you could enter the following formula and copy it down: =ABS(A2)
In excel what do you do with the second row or column?
There is no particular answer to that. You can do what you want with them. Often though, the first column and first row are kept for headings, so the second column and second row contain the first values on the spreadsheet.
What is a column chart in Excel?
It uses vertical bars, based on the values entered in as data. See the image at the link below.
What is the last column letter in Excel 2010?
That depends on the version. Up to version 2003, it was row 65,536. From Excel 2007 onwards, it is row 1,048,576.
Which is the column separator in excel?
column margin
