How to use division in a formula

So, 10 divided by 2 is entered as 10 / 2.

Let’s take a look.

The first formula doesn’t use any cell references.

We just input = 10 / 2, which gives a result of five.

We enter = D6 / 7 and get 3.

For C9 divided by H11, we enter = C9 / H11 which gives us -2.

When using division, you may see a VALUE error if any cells contain text.