Dividing numbers in cells
To use this Use a math service. / (slash)
for example 5÷6In the cell, the cell displaysas a formula =5/6
important: Make sure to type an equal sign (=) into the cell before you type numbers and separators / Otherwise, Excel translates what you type to a date. For example, if you type 7/30, Excel might display July 30 in the cell, or if you type 36/12/, Excel converts the value to 1/12/1936 first. and show Dec 1 in the cell
note: no function DIVIDE in Excel
Divide numbers using cell references
instead of typing the numbers directly into the formula. You can use cell references, such as F3 and C3, to refer to the numbers you want to divide and divide by.
0 ความคิดเห็น