Statements based on missing information

[kelly1]

I would like statements based on missing information to merge into documents.

As example

If name is missing = no name entered
If address 1 & 2 are missing = no address entered
If name and address is missing = no name or address entered

Book4.xls
	A	B	C	D	E	F	G	H	I
4
5		Name	PaulSmith			Statements
6					1	nonameentered
7		Address1	1TheNewRoad		2	noaddressentered
8		Address2	London		3	nonameoraddressentered
9
Sheet1

Thanks for any help


Kelly

 

[Norie]

Could you please supply some more information?

Are you trying to merge data from an Excel spreadsheet into a Word document?

 

[kelly1]

If C5 is blank, & C7 & C8 has an entry
Then return F6


If C5 has an entry, & C7 & C8 are blank
Then return F7


If C5 & C7 & C8 are blank
Then return F8


Is that ok?

No I’m not merging with Word, I can merge with Excel ok, I want to merge a statement based on that argument.

Kelly

 

[Norie]

I'm still not 100% sure what you are after.

Where do you want to 'return' these values?

You might want to take a look at the ISBLANK worksheet function.

 

[KenWright]

=IF(AND(C5="",C7<>"",C8<>""),F6,"")

=IF(AND(C5<>"",C7="",C8=""),F7,"")

=IF(AND(C5="",C7="",C8=""),F8,"")

Assumes you want nothing returned if criteria not met

 

[kelly1]

Thanks, works ok

Regards

Kelly