Formula Needed for Corresponding Blank Cell

[mjones]

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

 

[mjones]

Hi,

one idea without array formulas, using good old sumproduct()

=IF(SUMPRODUCT(--(B1:B10>0),--(ISBLANK(W1:W10)+ISBLANK(X1:X10)+ISBLANK(Y1:Y10))),"something's
missing","")

Adjust ranges to suit

hth

mjones;588088 Wrote:

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

--
teylyn

Telyn  --  'teylyn.posterous.com' (http://teylyn.posterous.com)
------------------------------------------------------------------------
teylyn's Profile: 983
View this thread:http://www.thecodecage.com/forumz/showthread.php?t=162866

Microsoft Office Help

Thanks! That works great. Although I'm not sure how old the
technique is because it seems like rocket science to me when you get
into double dashes.

I realize there is a situation when 'something's not missing'. Can I
add in the formula that it's okay and doesn't display "something's
missing" if A1:A10="Finalize invoice"?

Thanks again!

Michele