Nested IF Then statements

[kcompton]

Hi-
I have a spreadsheet (below) where I am trying to say Yes or No to whether or not a student met their goals.
If a student's At Above/Below Grade Level (column B) is "At Above" and their Spring End RIT column C is equal to or greater than One Year Growth (column D) then the Met Growth Goals (Column F) would = Yes, but if their At Above/Below Grade Level (column B) is "Below" and the Spring End RIT (column C) is Greater than or equal to the Fall RIT SEM (column A) PLUS 1.5 Year Growth ( Column E) then Met Growth Goal (column F) ="No"

I've tried a few options and can't make it work, and it occurs to me maybe it can't be done? Of if it can, can you help"

<style type="text/css">
table.tableizer-table {
font-size: 9px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>

Fall Rit + SEM	At Above /Below Grade Level	Spring End Rit _ SEM	1 year Growth	1.5 Year Growth	Met Growth Goals?
118.3	Below	151.3	159.1	28.7	=IF (B2="At Above" and C2 >= D2, then F2="Yes"), If (B2="Below" and C2 >= A2+E2 then F2="No"))
119.2	Below	138.2	159.1	28.7
141.1	At Above	170.3	159.1	28.7
138.2	Below	147.1	159.1	28.7
150.2	At Above	169.4	159.1	28.7

<thead>
</thead><tbody>
</tbody>

Thank you

 

[kcompton]

Re: Help needed with nested IF Then statements

Thanks for the tip

 

[kcompton]

Re: Help needed with nested IF Then statements

Thankyou!