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>







[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]Fall Rit + SEM[/TH]
[TH]At Above /Below Grade Level[/TH]
[TH]Spring End Rit _ SEM[/TH]
[TH]1 year Growth [/TH]
[TH]1.5 Year Growth[/TH]
[TH] Met Growth Goals?[/TH]
[/TR]
</thead><tbody> [TR]
[TD]118.3[/TD]
[TD]Below[/TD]
[TD]151.3[/TD]
[TD]159.1[/TD]
[TD]28.7[/TD]
[TD]=IF (B2="At Above" and C2 >= D2, then F2="Yes"), If (B2="Below" and C2 >= A2+E2 then F2="No"))[/TD]
[/TR]
[TR]
[TD]119.2[/TD]
[TD]Below[/TD]
[TD]138.2[/TD]
[TD]159.1[/TD]
[TD]28.7[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]141.1[/TD]
[TD]At Above[/TD]
[TD]170.3[/TD]
[TD]159.1[/TD]
[TD]28.7[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]138.2[/TD]
[TD]Below[/TD]
[TD]147.1[/TD]
[TD]159.1[/TD]
[TD]28.7[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]150.2[/TD]
[TD]At Above[/TD]
[TD]169.4[/TD]
[TD]159.1[/TD]
[TD]28.7[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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!