Need Help with Month of Next Audit

10 11 12 13 14 15 16 17 18 19 20 21 22 23 Client Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Size small large small small large small large large small small small small small small large large small small small small large large Pass or Fail In June fail pass pass pass pass pass fail pass fail fail fail fail pass fail pass pass pass pass pass pass pass pass Month of Next Audit Summary Info Use a formula to calculate number of... total number of firms large firms small firms audits in June failed audits in June passed large firms that passed the June audit small firms that passed the June audit Number of Future Audits by Month July August September Answer Answer Formula Formula Create a formula to determine when their next audit will be, based on the criteria below: If a firm is large and failed, their next audit is in July. If a firm is large and passed, their next audit is in September If a firm is small, their next audit is in August despite pass/fail status.