Is there a Division funtion in Excel?

S

Seaflower

Does anyone know if there is and what is the name for the division funciton
in Excel? I only found MOD, but no DIV in the funtions Excel provides. Thanks!
 
G

Gary's Student

In Excel division is not a function it is a language primitive like add,
subtract and multiply. If you want to divide the contents of A1 by B1 and
display the result in C1, enter


=A1/B1

in C1.

Good Luck
 
G

Gord Dibben

Seaflower

The / character is the division function.

=4/2 results in 2


Gord Dibben Excel MVP
 
M

Mike Middleton

Seaflower -
Does anyone know if there is and what is the name for the division
funciton in Excel? I only found MOD, but no DIV in the funtions Excel
provides. Thanks! <
Click to expand...

Most people use the division operator, i.e., slash. For example, to divide
the contents of A2 by the contents of A3, enter in some other cell =A2/A3.

In some situations you could use the QUOTIENT worksheet function, i.e.,
=QUOTIENT(A2,A3), but it returns only the integer portion of the division.

- Mike
www.mikemiddleton.com
 
Top