View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pignataro1@cox.net is offline
external usenet poster
 
Posts: 21
Default ERROR problem with Formula

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