I can use the BINOMDIST to find the sample size needed when I provide the required accuracy, confidence level, and number of errors. But I'd like to go the other way and find the number of allowed errors when I know the required accuracy, required confidence level, and number of trials. Is there a similar statistical function or formula I can use to do this? I've searched, but I'm not familiar enough with statistical functions to know if I'm just missing it or not.
Thanks in advance,
PS. Cross-posted. No reply in earlier MS Office forum.