+ Reply to Thread
Results 1 to 3 of 3

Divide number in one cell between columns

  1. #1
    Registered User
    Join Date
    10-01-2019
    Location
    england
    MS-Off Ver
    2010
    Posts
    1

    Divide number in one cell between columns

    I have had a lot of head scratching, I have a number in one cell which I need to divide into columns.

    For example

    A1 has the value 335
    I need to divide this by 110 (it will always be 110)

    I have this working, most likely in a very crude way but it works - almost. The result I am getting is 84 84 84 84 when I want it to read 84 84 84 83

    I would so grateful for any help, its taken me hours to get to this point

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Divide number in one cell between columns

    Please provide an example AND what the solution looks like (as per Forum Rules) - it will be much easier to assist you. When I divide 335 by 110 - I get 3.04545.

  3. #3
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Divide number in one cell between columns

    If you divide the number by 110 you will get 3.05, not 84. Assuming that you divide it by 4, then for the first 3 cells: =ROUNDUP($E$2/4,0)
    For last one: =ROUND(E2-SUM($F$3:$H$3),0)
    E2 contains 335
    F3:H3 - the first 3 cells.
    Click the * to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Divide column of data into user defined number of columns
    By redrocker12 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-04-2018, 09:37 PM
  2. Divide a column by a number and group results in columns of that number
    By AnthonyMarx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-02-2016, 02:06 PM
  3. Divide a number with cell containing txt and formula
    By adler in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-19-2015, 02:07 AM
  4. Macro to Divide a Data in Cells and Distribute to X number of Columns
    By paul.serrato in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 12:01 AM
  5. To divide value in each cell to the sum of the corresponding columns.
    By DanaGaraf in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2013, 06:13 AM
  6. Divide a number into multiple columns
    By monkeyman905 in forum Excel General
    Replies: 1
    Last Post: 10-25-2011, 02:57 PM
  7. Divide number and add remainder in another cell
    By rhon101 in forum Excel General
    Replies: 4
    Last Post: 11-29-2005, 10:10 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1