I am not sure you would call this simple, but try this formula in cell E1

=IF(AND(A1="JOB",OR(ISBLANK(B1),OR(ISBLANK(C1),ISB LANK(D1)))),"MISSING
INFO","ALL DATA THERE")



"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