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