=IF(AND) ASSISTANCE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VAN GOGH - 20 Jun 2006 15:42 GMT

Why doesn't this formula work?

=IF(AND('Detail by POG'!D1:D1000="Mainline Books - 12.5'",'Totals
Only'!B3='Detail by POG'!B1:B1000),"YES","NO")

Thanks.

Reply to this Message

Bob Phillips - 20 Jun 2006 15:56 GMT

Spurious apostrophe.

=IF(AND('Detail By POG'!D1:D1000="Mainline Books - 12.5",'Totals
Only'!B3='Detail By POG'!B1:B1000),"YES","NO")

But this onl;y tests the first cell, do you want any instance of that text
to register yes, if so

=IF(OR(ISNA(MATCH("Mainline Books - 12.5",'Detail By
POG'!D1:D100,0)),ISNA(MATCH('Totals Only'!B3,'Detail By
POG'!B1:B1000,0))),"NO","YES")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

> Why doesn't this formula work?
>
> =IF(AND('Detail by POG'!D1:D1000="Mainline Books - 12.5'",'Totals
> Only'!B3='Detail by POG'!B1:B1000),"YES","NO")
>
> Thanks.

Reply to this Message

Marcelo - 20 Jun 2006 15:57 GMT

Hi,

try this

=IF(AND(SUMPRODUCT(--('Detail by POG'!D1:D1000="Mainline Books -
12.5'")),SUMPRODUCT(--('Detail by POG'!B1:B1000='Totals
Only'!B3))),"YES","NO")

HTH
Regards from Brazil - going to the 6th *
Marcelo

> Why doesn't this formula work?
>
> =IF(AND('Detail by POG'!D1:D1000="Mainline Books - 12.5'",'Totals
> Only'!B3='Detail by POG'!B1:B1000),"YES","NO")
>
> Thanks.

Reply to this Message

JMB - 21 Jun 2006 04:18 GMT

Or does he want to know if the two criteria appear in the same row?

=IF(SUMPRODUCT(--('Detail by POG'!D1:D1000="Mainline Books -
12.5'"), --('Detail by POG'!B1:B1000='Totals
Only'!B3)),"YES","NO")

To respond to the OP's question of why it does not work - not easy to answer
when you don't tell anyone what you are trying to do.

> Hi,
>
[quoted text clipped - 14 lines]
> >
> > Thanks.

Reply to this Message