How do i define the "division" function on excel?
ex. 8.3/number in column D. It keeps giving me an error.
2006-12-12 02:50:37 · 4 answers · asked by Sui Generis 2 in Computers & Internet ➔ Software
Got it. Thanks.
2006-12-12 02:57:24 · update #1
Example for referencing cell D3:
= 8.3/D3
Just remember that cell D3 cannot equal 0 or be blank. A number cannot be divided by 0. And since a number can't be divided by 0, Excel will give you an error message for the answer with that formula.
To account for that you could set the formula up like this:
= IF(D3 <> 0, 8.3/D3, "")
That formula will make your cell blank if D3 equals 0.
2006-12-15 02:20:26 · answer #1 · answered by devilishblueyes 7 · 0⤊ 0⤋
=8.3/D(number of line) e.g. =8.3/D1
You do need to specify the row number of the cell or you will get an error
2006-12-12 02:59:12 · answer #2 · answered by Elizabeth Howard 6 · 0⤊ 0⤋
=8.3/[cell you are dividing by]
If the cell is empty or the value in the cell is zero, it will give you an error message.
2006-12-12 02:54:01 · answer #3 · answered by Navigator 7 · 0⤊ 0⤋
well, dont forget the = sign.. it should be =8.3/D4 ..where D4 is the number on column D..
2006-12-12 02:54:17 · answer #4 · answered by nol 2 · 1⤊ 0⤋