Results 1 to 2 of 2

Thread: How to divide a number by another value and show the range

  1. #1
    Neophyte rgreenidge's Avatar
    Join Date
    Jul 2019
    Posts
    1
    Articles
    0
    Excel Version
    Office 365

    Question How to divide a number by another value and show the range



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Is the following possible in Excel. I would like to take a number for example 2230 enter it in a cell, divide it by 1000 and
    have it return the following in a table:

    1 to 1000
    10001 to 2000
    2001 to 2230

    Is this possible in Excel? I am currently using Excel in Office 365

    Any help would be appreciated. Thanks in advance.

    Richard.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,282
    Articles
    0
    Excel Version
    Office 365 Subscription
    Firstly, your table data does not make sense - do you mean this?

    1 to 1000
    1001 to 2000
    2001 to 2230

    Secondly, 2230 divided by 1000 would be 2.23 - where/how should that be displayed? What exactly is the table for?

    Not enough information.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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