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.
Still curious? Ask our experts.
Chat with our AI personalities
Taiga
Devin
SteveAdd your answer:
Earn +20 pts
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 you find the mean of the data?
Add all the numbers together, than divide it by how many numbers you have. For exsample.... 32 49 61 are my numbers. add them all together (112) then divide by 3 because there are 3 numbers. so it would be. 37.2 Its the same thing as average.
