Results 1 to 8 of 8

Division function in Excel????

This is a discussion on Division function in Excel???? within the Excel Questions forums, part of the Question Forums category; I want to have a cell showing the quotient of A2, B2 ex. cell showing result of A2 divided by ...

  1. #1
    New Member
    Join Date
    Aug 2002
    Location
    Mahopac, NY
    Posts
    2

    Default

    I want to have a cell showing the quotient of A2, B2

    ex. cell showing result of A2 divided by B2

    I can't seem to find a formula that does this....does anyone know.

    I feel like this simple formula definitely has to be possible, but I read the whole list of formulas and can't find it.

    Please help.

  2. #2
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    61,553

    Default

    =A2/B2

    or am I missing something here?

  3. #3
    New Member
    Join Date
    Jul 2002
    Posts
    5

    Default

    =(a2/b2)

  4. #4
    IML
    IML is offline
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,744

    Default

    Not that you'd necessarily want to, but you could actaully call the function
    =QUOTIENT(A2,B2)
    instead of using the divison operators as listed above.

  5. #5
    New Member
    Join Date
    Aug 2002
    Location
    Mahopac, NY
    Posts
    2

    Default

    Thanks....that did work =(A2/B2)
    but why isn't it listed on the functions list?

  6. #6
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,055

    Default

    Because it's not a function, it's a formula.
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  7. #7
    Board Regular
    Join Date
    May 2002
    Posts
    810

    Default

    Because it's not a function, it's an arithetic operator.

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default

    For more on operators see the Excel Help topic for "Calculation operators in formulas".

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com