Is there a Division funtion in Excel?

[Guest]

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!

 

[Guest]

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

 

[Gord Dibben]

Seaflower

The / character is the division function.

=4/2 results in 2


Gord Dibben Excel MVP

 

[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! <

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