1. ## Question about Percentage Formula

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.

2. ## 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. ## 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?

4. ## 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. ## 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. ## 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:
`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

7. ## 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. ## Re: 2 Questions that I have yet found an answer to for Excel

Originally Posted by SpoonMan22
Formula:
`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. ## 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.

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

Sorry Arlu1201, this is not my thread

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

Sorry post 9 was addressed to Spring82.

12. ## Re: Question about Formula

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

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