Creating Sentences from excel foc

[signature1]

I'm having trouble finding a less complex way to create a notes section at the bottom of an excel doc. Here is some example data:<br>Format:<br>Person 1        <br>    cat 1 =    above 15%<br>    cat 2 =    binary<br>    cat 3 =    above x=10<br>Data:<br>James    <br>    10%<br>    0<br>    11<br>Jill    <br>    24%<br>    0<br>    10<br>Joey    <br>    14%<br>    1<br>    8<br>Jane    <br>    18%<br>    0<br>    9<br><br>NOTES HERE    <br><br>I want the notes section to fill automatically with each persons name and if they were below or at a certain number, percent, or binary. It needs to be in the form of a sentence. Thus the complication of pluralizing and maintaining correct sentence structure with cell references.<br>The output would be like this for category 1: " Jill and Jane had a higher percentage in category 1. This may have implications for other categories."<br>The output for category 2 would be: "Joey has completed category 2."<br>Output 3: "James is above the required amount."<br>I intended to do this with if/then statements but I thought there must be a more efficient way.<br>