Are you sure that the cells weren't "cleared" by pressing the spacebar,
in which case, they aren't blank?

Try:

=IF(AND(LEN(TRIM('Pietra Majella DI'!$I$34)) 0, LEN(TRIM('Pietra
Majella Ware'!$I$34)) 0), "ERROR", DI&WARE)


In article
,
wrote:

Hi,
Still having an issue-formula reads:

=IF(AND('Pietra Majella DI'!$I$34<"",'Pietra Majella Ware'!$I
$34<""),"ERROR",DI&WARE)


But ERROR is the message I'm getting even though there is only 1 cell
that has info. It should be reading 2-error should only come up if
both Ware and DI cells are filled by mistake.


Anyone have suggestions?


Thanks