Is there a Division funtion in Excel?

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

[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
--
Gary's Student


"Seaflower" wrote:

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

[Gord Dibben]

Seaflower

The / character is the division function.

=4/2 results in 2


Gord Dibben Excel MVP

On Mon, 29 Aug 2005 14:59:10 -0700, Seaflower
<Seaflower@discussions.microsoft.com> wrote:

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

[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