Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-1601363%22%20slang%3D%22en-US%22%3EFormula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601363%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20for%20some%20help%20with%20formulas.%20I%20am%20creating%20a%20QC%20document%20to%20check%20competence%20of%20Agents.%20The%20document%20includes%20an%20overall%20outcome%20section%2C%20plus%20the%20detail%20of%20all%20components.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20I%20have%20the%20following%20formula%20in%20the%20document%20to%20determine%20the%20outcome%20of%20the%20call%3A%3C%2FP%3E%3CP%3E%3DIF((OR(M14%3D%22No%22%2CM16%3D%22No%22%2CM18%3D%22No%22%2CM20%3D%22No%22%2CM22%3D%22No%22))%2C%22Family%20at%20risk%22%2C%22Family%20cared%20for%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20works%20on%20it's%20own%20but%20I%20am%20now%20trying%20to%20create%20an%20annual%20summary%20that%20will%20collate%20the%20results%20from%20multiple%20QC's%20completed.%20However%2C%20when%20the%20detail%20components%20are%20blank%20(not%20yet%20completed)%2C%20the%20formula%20i%20have%20defaults%20to%20an%20outcome%20showing%20%22Family%20Cared%20for%22.%20On%20my%20summary%20sheet%20however%2C%20this%20causes%20problems%20as%20it%20shows%20as%20this%20having%20an%20outcome.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20formula%20i%20can%20use%20for%20my%20outcome%20section%20(as%20shown%20by%20formula%20above)%20which%20when%20blank%20and%20uncompleted%20also%20shows%20as%20blank%20in%20the%20outcome%20box.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20makes%20sense.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1601363%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormula%20help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

I am looking for some help with formulas. I am creating a QC document to check competence of Agents. The document includes an overall outcome section, plus the detail of all components.

 

Currently I have the following formula in the document to determine the outcome of the call:

=IF((OR(M14="No",M16="No",M18="No",M20="No",M22="No")),"Family at risk","Family cared for")

 

This works on it's own but I am now trying to create an annual summary that will collate the results from multiple QC's completed. However, when the detail components are blank (not yet completed), the formula i have defaults to an outcome showing "Family Cared for". On my summary sheet however, this causes problems as it shows as this having an outcome.

 

Is there a formula i can use for my outcome section (as shown by formula above) which when blank and uncompleted also shows as blank in the outcome box.

 

I hope this makes sense.

 

Thanks,

0 Replies