I've been trying to come-up with excel formula that provide me with a answer if the condition that i set are being met?
Item Records Actual count Diff. % % Tolerance Tolerance ok? PCMA 525 541 3.0% 10.0% Yes PCLY 262 250 -4.6% 4.0% No
give me an answer of both yes..if possible to ask if there is a way that i can come up with the correction formulation.