Excel Division Formula
In a single cell, for example B2, an excel user can input the following formula:
= 5 / 2
The / symbol is found next to the SHIFT key on your keyboard.
Please note that there should be no spaces between the / and the numbers
You can also use actual cell references instead of numbers by taking the various cells you want calculated. For example:
Also, when combining multiplication with division within the same formula you will need to add Parentheses if you want to the division formula to work before the multiplication formula. Below is an example:
As you can see from the above example, the 5 and 5 are divided first to give you 1 then it is multiplying the 2 to give you an final answer of 2