What is spreadsheet formula in Open Office for dividing?

Answer 1

To do division in Excel you use the front slash character. You can click on the cell you want the formula in, and then you can type it like:

=B1/E4

This will divide the amount in B1 by the amount in E4.

You can use a cell and a value, like this:

=B2/10

or

=200/B5

Answer 2

In Excel, as in other areas of computing, the front slash is used for division. That is why it is on the Numeric keypad on a computer, along with the * for multiplication and the plus and minus signs. The front slash is also known as the solidus. To divide 10 by 5 you would type the following formula.

=10 / 5

Answer 3

Just use the / in the formula like this:

=A2/A3

That divides the value in A2 by the value in A3.

Answer 4

For the basic operations, you use the following symbols:

+ for addition

- for subtraction

* for multiplication

/ for division