IF formula-simple question; simple operator
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
|