Formula Needed for Corresponding Blank Cell
 

Hi All,

Well that didn't work:

=IF($B$7:$B$689<"",IF($W$7:$X$689="","SOMETHING IS MISSING",""),"")

And neither did this:

=IF($B$7:$B$689<"",IF(OR($W$7:$W$689=""),OR($X$7: $X$689=""),OR($Y$7:$Y
$689="")),"SOMETHING IS MISSING",""),"")

No laughing. I'm trying. And I did use Ctrl-Shift-Enter.

It's supposed to catch blank cells in columns W, X, or Y if column B
in the same row isn't blank. Column B is a date and W, X and Y are
text fields.

Any ideas?

Thanks again,

Michele