Special Education Formula

Hello,

I need help with a formula that will make this happen:

 

If the number in cell G4 is between 80%-100%, then cell I5 will say “Regular.”

If the number in cell G4 is between 40%-79%, then cell I5 will say “Resource.”

If the number in cell G4 is between 0%-39%, then cell I5 will say “Separate.”

 

Thank you so much.  It’s for calculating Special Education placement and I can’t get the three “if/then” statements to work. 


Rachel

 


By: Rachel Donnelly

Leave a Reply

Your email address will not be published. Required fields are marked *