excel - IF AND statement where all three conditions are met -
i have if , statement using . i trying ensure conditions met true. failing @ . please see formula below: =if(and(e5="yes",f5="closed",and( g5="no")),"found guy","that isn’t him") problem : above formula not returning correct value. example above formula should return "found guy" ie conditions have been satisfied. you not need have more 1 and. if true, , statement true. =if(and(e5="yes", f5="closed", g5="no"),"found guy","that isn’t him")