excel formula - Nested IF And Statement with text and value -
i trying create nested if statement says if column k = f , 0 return female non enrolled, if k= f , >0 return female enrolled, if k = m , 0 return male non enrolled, if k = m , >0 return enrolled. tried this: =if(and(k2=f,an2=0,"female non-enrolled",if(and(k2=f,an2>0,"female enrolled",if(and(k2=m,an2=0,"male non-enrolled","male enrolled")))))) there error, or perhaps doing wrong. help!
you didn't close , statements, piled parens @ end of formula. also, strings should in "" try this:
=if(and(k2="f",an2=0),"female non-enrolled",if(and(k2="f",an2>0),"female enrolled",if(and(k2="m",an2=0),"male non-enrolled","male enrolled")))
Comments
Post a Comment