+ Reply to Thread
Results 1 to 12 of 12

Question about Percentage Formula

  1. #1
    Registered User
    Join Date
    02-24-2013
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    10

    Question about Percentage Formula

    Please, can anyone help me???

    Question 1: I want to know if I can and if so how?

    I want to an accuracy percent for what a system says vs. what is actually counted. I have a cell for system & a cell for actual count. But the problem is one example the system will have 10 but count is 5 (50%). Another count may have system with 5 but count have 10 (50%). I need a formula that checks which is smaller then divides by larger number to give me a percentage regardless which is actually smaller, system or real count.



    Question 2: I want to know how to be able to have a work sheet read information from one sheet to another.

    I want to be able to compare those percentages from questions above in a different worksheet. So the example above we will say is February and I did four tests that gave me 4 different percentages which would be given by the above question. I would like on a different worksheet to have an another formula that would read all four results and give me an average of the four, for the entire month.
    Last edited by spring82; 02-26-2013 at 02:04 PM. Reason: Asked to

  2. #2
    Registered User
    Join Date
    02-24-2013
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: 2 Questions that I have yet found an answer to for Excel

    Also have excel 2003 on another computer if that helps or changes anything.

  3. #3
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: 2 Questions that I have yet found an answer to for Excel

    I am not really sure of what you mean by System vs Real?
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  4. #4
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: 2 Questions that I have yet found an answer to for Excel

    as for the second question, ='Sheet Name'!A1 will copy the contents of whatever 'Sheet Name' is,Cell A1 of that sheet into whatever sheet you place the formula in, or you could select a whole sheet, copy, select any cell on another sheet and hit paste/paste special(if you only want certain aspects copied) or if you just want a copy of the sheet, right click the name tab of sheet, select where you want it to appear, check the 'create a copy' checkbox, ok, then rename the sheet as appropriate..

  5. #5
    Registered User
    Join Date
    02-24-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: 2 Questions that I have yet found an answer to for Excel

    "I want to know how to be able to have a work sheet read information from one sheet to another."

    When you have started writing your formula when you need to enter your cell reference you have two options:

    You go to the other sheet and select teh area and the connection will be made.

    Or when making your cell reference in the formula bar you type the name of the sheet followed by a exclamation mark !.

    e.g.

    =SUM(Sheet2!A1,Sheet3!A1)

    I dont have enough insight to help with the other question, sorry.

    Hope this helps though, if only a little.

    SpoonMan

  6. #6
    Registered User
    Join Date
    02-24-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: 2 Questions that I have yet found an answer to for Excel

    In terms of your first question, I thought on it and it sounds to me like you could use this formula

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


    Where A and B are your system and actual count columns

    Just paste this into column C and drag it down to calculate the percentages

    I attached a workbook that I think does what you need
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    02-24-2013
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: 2 Questions that I have yet found an answer to for Excel

    What I mean by system vs real is the computer software might say I have 100 cups in my inventory but after counting them I reall have 85 cups. While it is 85% accurate and no problem. The problem I am having in excel is I may have 115. So I need a formula/logic in a cell that would compare these two numbers & make sure the smaller number goes into the larger number so I can get a % every time.

  8. #8
    Registered User
    Join Date
    02-24-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: 2 Questions that I have yet found an answer to for Excel

    Quote Originally Posted by SpoonMan22 View Post
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If A is larger than B, Then do A/B * 100, if not do B/A *100

    If A is not larger than B then B is larger than A

    It sounds like this will fix your problem

  9. #9
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: 2 Questions that I have yet found an answer to for Excel

    Spoonman22,

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  10. #10
    Registered User
    Join Date
    02-24-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: 2 Questions that I have yet found an answer to for Excel

    Sorry Arlu1201, this is not my thread

  11. #11
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: 2 Questions that I have yet found an answer to for Excel

    Sorry post 9 was addressed to Spring82.

  12. #12
    Registered User
    Join Date
    02-24-2013
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Question about Formula

    I want to thank everyone for assisting me; and SpoonMan22 for answering my question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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