=(AND Function

[mikehk]

I am using this formula for CF, it won't work, please help me correct it.

=(AND(ISTEXT(2018!$C2)*LEN(2018!$C2),ISTEXT(2018!$E2)*(LEN(2018!$E2),ISTEXT(2018!$G2)*(LEN(2018!$G2))))))



Thanks.

[¯\_(ツ)_/¯]

Maybe...

=AND(ISTEXT('2018'!$C2)*LEN('2018'!$C2),ISTEXT('2018'!$E2)*LEN('2018'!$E2),ISTEXT('2018'!$G2)*LEN('2018'!$G2))

? Not sure why your checking to see if a cell contains text, and then multiplying it by its length, to be honest. I'd think just checking for text would suffice to get TRUE/FALSE values for the AND function.

=AND(ISTEXT('2018'!$C2),ISTEXT('2018'!$E2),ISTEXT('2018'!$G2))

[mikehk]

I added a column and simplified the CF condition. Thanks for your help.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Please see forum rule #1 and use more meaningful thread titles in future.