answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

15y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you add and divide numbers in the same cell in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

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.


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.


What happens in Excel when you clear a cell?

Same as deleting its content.


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.