Ok I have a formula I would like to use. Hopefull it is possible and hopfully I can explain this right. I have created a spread sheet to test the torque readings of a wrench. Using a torque test device and third party software to transfer the test results to an excel spread sheet. I have 5 numbers that I have to add and then devide them to get the average of the 5 (thats done). I then need to find out if this average is with in plus or minus a percentage of another number. So example.
20+18+20+19+17 =94 /5 = 18.8 (the average) Now then is that 18.8 with in 4% + or – of lets say 20.
My numers are going to be much different depending on what the foot lbs we are testing but for ease I used those numbers. I would also like to display the answer with the number in either green for a pass or red for a fail. Is that possible ????
Hopefull that is explained so you can understand.
Thanks