0
Formulas can include a mix of calculations, so you can put several in, and have very long calculations. The only thing you need to know is how calculations are done when you have a mixture of operations in a cell. In this case, all divisions will be done before any additions, no matter where they appear in the calculation. That is a law of mathematics, an spreadsheets will follow that. For example, if you take this formula:
=5+6/2
In this case, the 6 will be divided by the 2, before the 5 is added to it. If you want the 5 added to the 6 first, then you have to put brackets around that part of it like this:
=(5+6)/2
The laws of mathematics dictate that anything inside brackets is done first, which is why that happens.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How do you average two negative numbers?
Same way as for positive numbers: add them together and divide by two.
How can you work the 'mean' in maths?
Same as average. For example, if you have 5 numbers, add them all up, then divide the result by 5. If you have 10 numbers, you add and divide by 10, etc.
How do find the median of four numbers that are not the same?
You would add the two numbers in the middle and divide them by two and the answer would be the median.
How do you mulyiply and divide negative numbers by positive numbers?
1). First, ignore the signs. Just go ahead and multiply or divide the numbers as if they were both positive.Then, when you have that answer . . .2). If both of the original numbers had the same sign, then the answer is positive.If the original numbers had different signs, then the answer is negative.
How do you find a midpoint of two numbers?
To find the midpoint add the two numbers and divide the sum by two. This is the same as the mean or the average of the two numbers.
How can you change numbers to text in an Microsoft Excel worksheet?
Select cell formatting and change to text. After than, Excel will treat the numbers in a cell the same as any other text characters. Also, you will not be able to use that cell in a formula, because the formula will not recognize the characters as numbers.
What happens in Excel when you clear a cell?
Same as deleting its content.
Is charting in Powerpoint the same as charting in Excel?
Yes, they are the same. Powerpoint isn't for dealing with numbers generally, but you can set up tables of numbers and create charts from them, like you do in Excel.
When you enter a formula in a cell Excel assigns the cell the same format as the cell reference in the formula?
first
How can you add percentage to all numbers in same column on excel?
Get an accountant
When does Excel assign the SUM function to cells next to numbers?
It you select the blank cell under a column of numbers or a blank cell at the end of a row of numbers and hit the Autosum button it will enter the SUM function and select the cells above in the column, or to the left in a row. Pressing Alt and the = key will also do the same thing. If you select the column or the row with the numbers and click the button or do Alt and the = key, then it will also do the same.
In excel how do you underline the characters in a cell and not the entire cell?
If this is an Excel question, you can underline words the same as in MS Word - use the 'U' icon or 'Format-font-underline'. The format is called 'underline.'
How do you get the mean ofa improper fractions?
Same as for other numbers. You sum them together and divide the result by the number of fractions.Same as for other numbers. You sum them together and divide the result by the number of fractions.Same as for other numbers. You sum them together and divide the result by the number of fractions.Same as for other numbers. You sum them together and divide the result by the number of fractions.
How do I retain Excel cell formatting during mail merge into a table in Word?
Merge brings one to several individual cells from Excel into Word. The formatting in the merged Word document depends on Word, not Excel. If you would like to retain the same formatting as you had in Excel, then format the target location in Word to match the cell from Excel.
How do you divide into uneven numbers?
the same way you divide even numbers. jus at the and put remainder= r. andput the number...hope this helps... if not sorry...
How do you enter same value in every cell in Excel in mac entourage?
There is no direct connection between Excel and Entourage, but if you highlight all the cells from Excel and go to Entourage, you should be able to paste the data.
How do you average two negative numbers?
Same way as for positive numbers: add them together and divide by two.
