In E1 enter:
=IF(OR(ISBLANK(B1),ISBLANK(C1),ISBLANK(D1)),"MISSI NG INFO","")


"Rich D" wrote:

If the entry in A1 is "Job", and if any of the cells B1, C1, D1 are blank, I
want to return (in cell E1) the message "MISSING INFO". I know it's simple
but I'm missing something myself.

Thanks,
--
Rich D
Armstrong Custom Homes
Redmond