+ Reply to Thread
Results 1 to 2 of 2

formula to help with percentages

  1. #1
    Registered User
    Join Date
    10-13-2016
    Location
    northern ireland
    MS-Off Ver
    office 365 Mac
    Posts
    2

    formula to help with percentages

    i am trying to work out a simple formula to help me determine how many more items i need to sell with an attachment to hit my preferred attachment percentage. i.e. the target is 36% which is located in cell G6. my colleague is currently on 31.6% which I input into cell G7. This is based on them having sold 19 items, which is input in cell C7. I know they need to sell 2 more attached items to get above the 36% target. but i would like a quick way of showing than for multiple colleagues.

    Thanks in advance
    Richard

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,909

    Re: formula to help with percentages

    Try this ...

    =ROUNDUP(C7/G7*($G$6-G7),0)

+ 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] Sum monthly percentages into quarterly percentages
    By Zyphon in forum Excel General
    Replies: 6
    Last Post: 06-11-2015, 04:40 AM
  2. IF formula with different percentages %
    By Sarah Lovell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-03-2014, 01:16 AM
  3. Reversing input percentages against variable percentages.
    By Journeyman3000 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-26-2014, 08:56 PM
  4. [SOLVED] Percentages formula
    By daxcrocker in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-19-2014, 05:52 PM
  5. Formula with Different Percentages
    By KimMerc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-22-2012, 03:44 PM
  6. [SOLVED] Formula for Percentages?
    By ChristyT71 in forum Excel General
    Replies: 6
    Last Post: 09-12-2011, 05:00 PM
  7. [SOLVED] Re: formula for percentages
    By Tracy in forum Excel General
    Replies: 0
    Last Post: 05-11-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