+ Reply to Thread
Results 1 to 2 of 2

I am looking for help setting up Division calculations with a remainder

  1. #1
    Registered User
    Join Date
    06-17-2019
    Location
    Tucson, AZ
    MS-Off Ver
    Excel online
    Posts
    1

    I am looking for help setting up Division calculations with a remainder

    Hello,
    Please let me explain what I am trying to do first so it makes sense. I have tried to research it but have not found any answers. Thank you for any help. I need to divide the numbers in two different cells. That is easy enough. What I need to do from there though, is but the whole integer in one cell and the remainder in another. I am creating a spreadsheet to keep track of sales. If you buy one of my product it is $5, if you buy 2, it is $8. I need to take the total ordered and divide it by 2 to find the number of $8 deals a customer gets. If it is an odd number and there is a remainder of .5, I need to put that into another column and round it up to 1. That way I can add up the totals of $8 deals and $5 deals. Any advice on the best way to go about this? Thank you!

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: I am looking for help setting up Division calculations with a remainder

    Hi
    If your quantity is in A1 and value in B1
    Use this in C1
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    and this in D1

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    (copy down)

+ 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. Replies: 2
    Last Post: 06-18-2018, 06:31 PM
  2. [SOLVED] Need help with setting a formula to with Rounding and Moving the remainder
    By filmhandler in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-21-2017, 04:44 PM
  3. division gives wrong answer (division)
    By Brice in forum Excel General
    Replies: 5
    Last Post: 12-24-2010, 10:13 PM
  4. Replies: 2
    Last Post: 11-15-2006, 11:04 PM
  5. [SOLVED] Need formula help setting a range for calculations
    By Sharona77 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-13-2006, 08:45 PM
  6. [SOLVED] Setting up "Year to Date" Calculations in a Pivot Table
    By Project64 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2005, 10:06 PM
  7. [SOLVED] remainder in a division
    By sinbad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2005, 05:06 AM

Tags for this Thread

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