Conditional Formulas Maybe?

J

jrose

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.
 
B

Bob Phillips

=(If(OR(AND(Y6=1,N55<30),AND(Y6=2,N55<60)),"You are in danger of not
graduating","Congrats")

If the scale is linear, a simpler formula could be devised for many values
of Y

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
J

jrose

Thanks bob. this worked! However, now what i need is to add one more cell to
this. I have a second pull down that will have just 2 answers. A10=1 or
A10=2. I need to add this to the requirements for If statement so that if
Y6=1, N55<30 AND a10=1 the message "yoiu are in danger of not graduating"
will pop up HOWEVER if they selected A10=2 then N55 needs to be a different
number for the same message to pop up. This seems almost too complicated to
even explain. Please let me know if there is a way. This is the only thing
keeping me from total success on this form!
 
B

Bob Phillips

=(If(OR(AND(A10=1,Y6=1,N55<30),AND(A10=2,Y6=1,N55<69),AND(Y6=2,N55<60)),
"You are in danger of not graduating","Congrats")

I chose an arbitrary number of 69 for A10=2

Is this what you need?


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top