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.

I am not really sure of what you mean by System vs Real?

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..

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.

Sorry post 9 was addressed to Spring82.