Still not understanding how use IF...AND

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

jctlcdc

I am using the following formula which works fine but I would like t
add an 'AND' condition which would be and AO2>=0 then the PHI, PHII o
PHIII. I just can't seem to get the AND part down correctly. Any hel
appreciated. I could attached a couple of rows of the worksheet i
that would.:confused
 
Hi
try
=ÍF(AO2>=0,IF(AI2>=24,"PHIII",IF(AI2>=12,"PHII",IF(AI2<12,"PHI"))),"")
if I understood you correctly.

for the AND function: You use it like
=IF(AND(AO2>=0,AI2>=24),"PHIII","something else")
 
=IF(AND(AI2>=24,AO2>=0),"PHIII",IF(AND
(AI2>=12,AO2>=0),"PHII",IF(AND(AI2<12,AO2>=0),"PHI")))

HTH
Jason
Atlanta, GA
 
Back
Top