And if isblank

[Jack Byrindi]

Hi people I and trying to check if the value in three cells if any one of them is blank then the result is nothing. If all three contain something then the word "Completed" is printed in the cell.

I am ok with Basic formulas, but this is a bit past me.

Can anyone help me, this is what I have so far.

=IF(OR(AND(ISBLANK(I11),""),AND(ISBLANK(A12),""),AND(ISBLANK(A13),"")),"","Completed")

Thanks

[martindwilson]

=if(or(I11="",a12="",a13=""),"","completed")

[Jack Byrindi]

Wonderful. Very easy when you know how.
Thanks so much