# Reverse false and combine with true true value

1. ## Reverse false and combine with true true value

I am trying to create a formula as follows:
Cell B3: should not contain word "Fines"

Managed to create a formula that gives me the right output when both are
conditions are met, though having problem reversing the false into true for
Cell B3
Formula created is as follows:
IF(AND(ISNUMBER(FIND("Plant",B2))*ISNUMBER(SEARCH("Fines",B3))),"Include","N/A")

Where do I go wrong?
Thanks a lot!

2. ## RE: Reverse false and combine with true true value

Try taking out the AND() statement, you don't need it because you are
multiplying each boolean expression in your formula. Then, the only time you
will get a TRUE statement is if each ISNUMBER() returns TRUE. For example:

TRUE*TRUE = TRUE
TRUE*FALSE = FALSE
FALSE*FALSE = FALSE
--
Regards,

DavidB

"Emmie99" wrote:

> I am trying to create a formula as follows:
> Cell B2: should read "Plant"
> Cell B3: should not contain word "Fines"
>
> Managed to create a formula that gives me the right output when both are
> conditions are met, though having problem reversing the false into true for
> Cell B3
> Formula created is as follows:
> IF(AND(ISNUMBER(FIND("Plant",B2))*ISNUMBER(SEARCH("Fines",B3))),"Include","N/A")
>
> Where do I go wrong?
> Thanks a lot!

3. ## RE: Reverse false and combine with true true value

Emmie99
The NOT function reverses TRUE/FALSE so try
IF(AND(ISNUMBER(FIND("Plant",B2)),NOT(ISNUMBER(SEARCH("Fines",B3)))),"Include","N/A")
--

Simon

"Emmie99" wrote:

> I am trying to create a formula as follows:
> Cell B2: should read "Plant"
> Cell B3: should not contain word "Fines"
>
> Managed to create a formula that gives me the right output when both are
> conditions are met, though having problem reversing the false into true for
> Cell B3
> Formula created is as follows:
> IF(AND(ISNUMBER(FIND("Plant",B2))*ISNUMBER(SEARCH("Fines",B3))),"Include","N/A")
>
> Where do I go wrong?
> Thanks a lot!

4. ## RE: Reverse false and combine with true true value

Hi DaveB,
Sorry but this does not solve the problem. The real problem I have is with
the reverse false statement.
I cannot get to exclude the word "Fines" in cell B3....
Any other alternative?
Thanks and regards,

"DaveB" wrote:

> Try taking out the AND() statement, you don't need it because you are
> multiplying each boolean expression in your formula. Then, the only time you
> will get a TRUE statement is if each ISNUMBER() returns TRUE. For example:
>
> TRUE*TRUE = TRUE
> TRUE*FALSE = FALSE
> FALSE*FALSE = FALSE
> --
> Regards,
>
> DavidB
>
>
> "Emmie99" wrote:
>
> > I am trying to create a formula as follows:
> > Cell B2: should read "Plant"
> > Cell B3: should not contain word "Fines"
> >
> > Managed to create a formula that gives me the right output when both are
> > conditions are met, though having problem reversing the false into true for
> > Cell B3
> > Formula created is as follows:
> > IF(AND(ISNUMBER(FIND("Plant",B2))*ISNUMBER(SEARCH("Fines",B3))),"Include","N/A")
> >
> > Where do I go wrong?
> > Thanks a lot!

5. ## RE: Reverse false and combine with true true value

Oh sorry about that I mis-understood. Ya as Simon said the NOT() function
reverses boolean values, so TRUE becomes FALSE and FALSE becomes TRUE. You
can still take out the AND() function, though, if you are multiplying each
boolean value together. If you want to keep it in replace the multiplication
(*) with a comma (,)
--
Regards,

DavidB

"Emmie99" wrote:

> Hi DaveB,
> Sorry but this does not solve the problem. The real problem I have is with
> the reverse false statement.
> I cannot get to exclude the word "Fines" in cell B3....
> Any other alternative?
> Thanks and regards,
>
>
> "DaveB" wrote:
>
> > Try taking out the AND() statement, you don't need it because you are
> > multiplying each boolean expression in your formula. Then, the only time you
> > will get a TRUE statement is if each ISNUMBER() returns TRUE. For example:
> >
> > TRUE*TRUE = TRUE
> > TRUE*FALSE = FALSE
> > FALSE*FALSE = FALSE
> > --
> > Regards,
> >
> > DavidB
> >
> >
> > "Emmie99" wrote:
> >
> > > I am trying to create a formula as follows:
> > > Cell B2: should read "Plant"
> > > Cell B3: should not contain word "Fines"
> > >
> > > Managed to create a formula that gives me the right output when both are
> > > conditions are met, though having problem reversing the false into true for
> > > Cell B3
> > > Formula created is as follows:
> > > IF(AND(ISNUMBER(FIND("Plant",B2))*ISNUMBER(SEARCH("Fines",B3))),"Include","N/A")
> > >
> > > Where do I go wrong?
> > > Thanks a lot!

6. ## RE: Reverse false and combine with true true value

Thanks a million! Solved!

"Simon Letten" wrote:

> Emmie99
> The NOT function reverses TRUE/FALSE so try
> IF(AND(ISNUMBER(FIND("Plant",B2)),NOT(ISNUMBER(SEARCH("Fines",B3)))),"Include","N/A")
> --
>
>
> Simon
>
>
> "Emmie99" wrote:
>
> > I am trying to create a formula as follows:
> > Cell B2: should read "Plant"
> > Cell B3: should not contain word "Fines"
> >
> > Managed to create a formula that gives me the right output when both are
> > conditions are met, though having problem reversing the false into true for
> > Cell B3
> > Formula created is as follows:
> > IF(AND(ISNUMBER(FIND("Plant",B2))*ISNUMBER(SEARCH("Fines",B3))),"Include","N/A")
> >
> > Where do I go wrong?
> > Thanks a lot!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1