Conditional Formulas Maybe?
 

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.

Conditional Formulas Maybe?
 

=(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)

"jrose" wrote in message
...
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.

Conditional Formulas Maybe?
 

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!

"Bob Phillips" wrote:

=(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)

"jrose" wrote in message
...
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.

Conditional Formulas Maybe?
 

=(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)

"jrose" wrote in message
...
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!

"Bob Phillips" wrote:

=(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)

"jrose" wrote in message
...
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.