What is the appropriate to create a new column in the data that has multiple IF statements. Below is what I started but I think I am missing something. I am trying to use nested IF statements. I know how to do it when dealing with less than or equal to but in the case where its equal and there is no false I am new to that and likely over thinking it.
Based on the Academic Year in the Academic Year Column I am trying to sign a specific number, which is the Cost of Instruction.