Results 1 to 8 of 8

Thread: Division function in Excel????

  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
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651

    Default

    =A2/B2

    or am I missing something here?

  3. #3

    Default

    =(a2/b2)

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743

    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,053

    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