I am rusty on IF Statements and I need help with building one with different conditions.
My if statement works with I use one condition but I am getting an error when I try to add more conditions.
Based on OJT % column that has a number between 0 and 100 I want the IF statement column to reflect:
"Beginning Apprentice" if the number is between 0-25
"Intermediate Apprentice" if the number is between 26-50
"Advanced Apprentice" if the number is between 51-74
"Eligible for Completion" if the number is between 75-100
Can any one tell me how to add the other 3 conditions to the simple IF statement I have, corectly?
=IF([WH OJT %]@row < 26, "Beginning Apprentice")
Help Article Resources
Check out the Formula Handbook template!