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

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

On Dec 10, 10:38 am, JE McGimpsey wrote:
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- Hide quoted text -

- Show quoted text -

Yes, I have to clear using spacebar and 34 is merged with 35-are these
the problems?

Thanks

Yes. The spacebar doesn't "clear" anything - it inserts space characters
in the cell.

And while merged cells are the spawn of the devil, and should never be
used, not even once, they aren't the problem in this case.

The formula I gave you works with "spaced", merged cells.


In article
,
wrote:

Yes, I have to clear using spacebar and 34 is merged with 35-are these
the problems?

On Dec 10, 11:16 am, JE McGimpsey wrote:
Yes. The spacebar doesn't "clear" anything - it inserts space characters
in the cell.

And while merged cells are the spawn of the devil, and should never be
used, not even once, they aren't the problem in this case.

The formula I gave you works with "spaced", merged cells.

In article
,



wrote:
Yes, I have to clear using spacebar and 34 is merged with 35-are these
the problems?- Hide quoted text -

- Show quoted text -

Still confused. I'm getting a #NAME? result now. Even though I typed
in: 2 cs into 1 of the sheets cell. Any new suggestions?

Thanks

What formula and what values of the input cells gave you #NAME?


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ...
| On Dec 10, 11:16 am, JE McGimpsey wrote:
| Yes. The spacebar doesn't "clear" anything - it inserts space characters
| in the cell.
|
| And while merged cells are the spawn of the devil, and should never be
| used, not even once, they aren't the problem in this case.
|
| The formula I gave you works with "spaced", merged cells.
|
| In article
| ,
|
|
|
| wrote:
| Yes, I have to clear using spacebar and 34 is merged with 35-are these
| the problems?- Hide quoted text -
|
| - Show quoted text -
|
| Still confused. I'm getting a #NAME? result now. Even though I typed
| in: 2 cs into 1 of the sheets cell. Any new suggestions?
|
| Thanks