+ Reply to Thread
Results 1 to 2 of 2

Formula for percentage for under delivery of items

  1. #1
    Registered User
    Join Date
    12-20-2018
    Location
    London
    MS-Off Ver
    2010
    Posts
    4

    Formula for percentage for under delivery of items

    Hi,

    Please could someone help me. I am trying to get a formula to show me records that that have delivered less that 25% of items. I have worked out the total percentage but now want to see how many have under delivered.

    Please could someone let me know how to calculate this.

    Many thanks

    Deepi

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,880

    Re: Formula for percentage for under delivery of items

    Hello and welcome to the forum.

    I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

    To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"

+ 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] Formula to show percentage difference for one column and then items needed based on result
    By rhett7660 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-30-2016, 01:14 PM
  2. [SOLVED] Production and Delivery Formula
    By Mike121 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-14-2015, 01:07 PM
  3. Delivery Schedule Percentage
    By whodatfan2009 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-27-2014, 11:11 PM
  4. distribution of percentage if 2 items deleted
    By senjuti.sarkar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-16-2014, 06:39 AM
  5. Replies: 2
    Last Post: 06-05-2013, 12:14 PM
  6. [SOLVED] calculating 10 percentage of items in a column
    By ysymon in forum Excel General
    Replies: 2
    Last Post: 08-24-2005, 12:05 PM
  7. [SOLVED] Delivery note or delivery order sheet
    By Roy Istanbouli in forum Excel General
    Replies: 1
    Last Post: 01-21-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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1