+ Reply to Thread
Results 1 to 5 of 5

need convert pieces sold to cases configuraation

Hybrid View

  1. 01-29-2015, 04:45 AM #1
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,620

    Re: need convert pieces sold to cases configuraation

    Perhaps =QUOTIENT(A1,20)+MOD(A1,20)/100
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  2. 01-29-2015, 05:23 AM #2
    jebi
    jebi is offline
    Registered User
    Join Date
    01-29-2015
    Location
    uae
    MS-Off Ver
    office2010
    Posts
    3

    Re: need convert pieces sold to cases configuraation

    A1=6, B1=8, C1= need to get 1.02 (need formula in C1 to get this figure
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Add cases opened and closed for each month and specifics about the cases.
    By ChrisLaRoc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-04-2014, 08:19 PM
  2. We want a formula that will show items sold by the day and the net amount sold on that day
    By Mark Quan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2013, 09:17 PM
  3. Parsing into three pieces
    By Viewson in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-26-2011, 06:18 AM
  4. [SOLVED] Cases within Cases
    By mtm4300 via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-18-2006, 09:45 PM
  5. Three Cases
    By teresa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2005, 02:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1