Hello, i am not sure what i am looking for but here is what i want to happen.
I have a pull down that is linked to cell y6. If Y6=1 AND N55 is less than
lets say "30" i want it to return "You are in danger of not graduating"
otherwise "Congrats" BUT If Y6 =2 AND N55 is less than 60 i want the same
thing to happen. Basically what i am doing is trying to display a message
based on what grade the student is in and how many credits they should have
obtained by the end of that year. If they did not meet the required number of
credits, then i want a message to pop up. Hope this makes sense.