Zeros in Formulas

Hello, I have a formula that uses several different cells. If one of those cells is blank I would like the formula to result in "Incomplete". Can this be done?

Maybe something like:

=IF(OR(A1="",B1="",C1=""),"Incomplete",YourCalcHere)

replacing YourCalcHere with whatever your formula is currently.

If these cells form a contiguous range, then maybe:

=IF(COUNTIF(A1:C1,"")>0,"Incomplete",YourCalcHere)

Thanks a million, you've made me look a like a wizard here at work! I'll be sure to give you credit though