+ Reply to Thread
Results 1 to 3 of 3

To simple to figure out.

Hybrid View

  1. #1
    Registered User
    Join Date
    09-04-2013
    Location
    Wisconsin Rapids, WI, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    To simple to figure out.

    The title of my thread may refer to the solution to my question or perhaps to me. I guess I'll see.
    Here is my problem/need. I work for a newspaper and we receive the morning paper in bundles of 50. I am working on a caculator that will tell my dock person exactly how may bundles and how many odd papers should be received off the truck on any given day.
    Adding up each carrier's paper count and dividing them by 50. If, for example, I require 125 papers, I need this total to be reflected in two seperate cells. One to give me the total number of full bundles and one to give me the number of odd papers. In this case of course I would need 2 full bundles and 25 odd papers.
    So here's where I'm stuck. Dividing the 125 papers by 50 gives me 2.5 bundles in the "Totoal Bundles" cell. I need this to round down to 2 bundles and the "Odd Papers" cell needs to read 25.
    Can this be done?
    Thanks

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,411

    Re: To simple to figure out.

    Use this to get the number of bundles:

    =INT(A1/50)

    assuming 125 is in A1, then use this to get the number of single papers:

    =MOD(A1,50)

    Hope this helps.

    Pete

    Next time use a title that describes your problem - they are quite hot on that in this Forum (see Forum Rules at top of screen).

  3. #3
    Registered User
    Join Date
    09-04-2013
    Location
    Wisconsin Rapids, WI, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: To simple to figure out.

    Thank you Pete, I really appreciate you quick and accurate response. That was spot on. I'll do better on the titles from now on as well. I promise.
    Thanks again.

+ 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. simple vlook up issue...cannot figure out
    By putitwhere in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2013, 01:25 PM
  2. Probably Simple Countif but i can't figure it out
    By ssword in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-12-2011, 11:52 AM
  3. Simple IF variable, but cant seem to figure out how
    By ginjack in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-24-2009, 08:56 PM
  4. Why can't I figure out this simple formula...???
    By HuskerBronco in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-23-2006, 12:22 PM
  5. A simple Date formula that I cant figure out
    By Bigredno8 in forum Excel General
    Replies: 3
    Last Post: 05-14-2005, 11:58 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