Back to if...and adding another and

  • Thread starter Thread starter jctlcdc
  • Start date Start date
J

jctlcdc

=IF(AND($AO2>=0,$AI2>=24),"PHIII",IF(AND(AP2>=0,AJ2>=12),"PHII","PHI"))

This formula works fine but now I am needing to add another "and" whic
would be column AT. I just want to put an x in the column for true an
leave it blank for false. Thanks for your patience and answers i
advance
 
Hi
not quite sure what you're trying to achieve. Ho do you want this
combined with your existing criteria?
 
What will you test AT for, and which AND is it to be combined with?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks for your replies. Sorry I was not clear enough before. Thi
would be an addtional criteria for moving from phase I (PHI) to PHII.
Such as in the existing formula - one criteria is a balance of 0 $'s o
greater and another is how many times they have attended. It would b
for me to easily indicate if the individual has a sponsor or not.

=IF(AND($AO2>=0,$AI2>=24),"PHIII",IF(AND(AP2>=0,AJ2>=12),"PHII","PHI"))

It could be just a matter of putting an "x" in that cell (AT2) for tru
and leaving it blank for false
 
Hi
maybe something like
=IF(AND($AO2>=0,$AI2>=24),"PHIII",IF(AND(AP2>=0,AJ2>=12,AT2="x"),"PHII"
,"PHI"))
 
Back
Top