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>
<thead>
</thead><tbody>
</tbody>
Thank you
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