Convert TRUE/FALSE results to a number

[pomalley]

I’m using the following function in cell C3:

=IF($A1="Network", AND(ISNUMBER(FIND("h",$B3))))

The result in C3 is TRUE. If the value in A1 = network and the value in B3
is “h�, give me the number 1 in cell C3 instead of TRUE. If the result is
FALSE, I’d like the cell to be blank. Any ideas are greatly appreciated.

[Don Guillett]

=if(conditionistrue,1,"")

--
Don Guillett
SalesAid Software
donaldb@281.com
"pomalley" <pomalley@discussions.microsoft.com> wrote in message
news:D9481CD3-C45C-4466-9145-6E0B07D246FF@microsoft.com...
> I'm using the following function in cell C3:
>
> =IF($A1="Network", AND(ISNUMBER(FIND("h",$B3))))
>
> The result in C3 is TRUE. If the value in A1 = network and the value in
B3
> is "h", give me the number 1 in cell C3 instead of TRUE. If the result is
> FALSE, I'd like the cell to be blank. Any ideas are greatly appreciated.
>

[pomalley]

Thanks for the prompt reply but I'm not clear where I would use this. Is it
part of my of my original function or am I entering this in yet another cell.
I tried a number of combinations with my calculation but can't seem to make
it work. I guess I need more information. Thanks.

"Don Guillett" wrote:

> =if(conditionistrue,1,"")
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "pomalley" <pomalley@discussions.microsoft.com> wrote in message
> news:D9481CD3-C45C-4466-9145-6E0B07D246FF@microsoft.com...
> > I'm using the following function in cell C3:
> >
> > =IF($A1="Network", AND(ISNUMBER(FIND("h",$B3))))
> >
> > The result in C3 is TRUE. If the value in A1 = network and the value in
> B3
> > is "h", give me the number 1 in cell C3 instead of TRUE. If the result is
> > FALSE, I'd like the cell to be blank. Any ideas are greatly appreciated.
> >
>
>
>

[N Harkawat]

Simply put a -- (double negative) in front of your formula to look like this

--IF($A1="Network", AND(ISNUMBER(FIND("h",$B3))))

becasue --(True) is equal to 1 and --False = 0


"pomalley" <pomalley@discussions.microsoft.com> wrote in message
news:D9481CD3-C45C-4466-9145-6E0B07D246FF@microsoft.com...
> I'm using the following function in cell C3:
>
> =IF($A1="Network", AND(ISNUMBER(FIND("h",$B3))))
>
> The result in C3 is TRUE. If the value in A1 = network and the value in
> B3
> is "h", give me the number 1 in cell C3 instead of TRUE. If the result is
> FALSE, I'd like the cell to be blank. Any ideas are greatly appreciated.
>

[Don Guillett]

What I was saying way to encompass your formula
=if(a1=2,1,"")

--
Don Guillett
SalesAid Software
donaldb@281.com
"pomalley" <pomalley@discussions.microsoft.com> wrote in message
news:A0005200-D60A-4E83-A83E-A9CBB5AA17B3@microsoft.com...
> Thanks for the prompt reply but I'm not clear where I would use this. Is
it
> part of my of my original function or am I entering this in yet another
cell.
> I tried a number of combinations with my calculation but can't seem to
make
> it work. I guess I need more information. Thanks.
>
> "Don Guillett" wrote:
>
> > =if(conditionistrue,1,"")
> >
> > --
> > Don Guillett
> > SalesAid Software
> > donaldb@281.com
> > "pomalley" <pomalley@discussions.microsoft.com> wrote in message
> > news:D9481CD3-C45C-4466-9145-6E0B07D246FF@microsoft.com...
> > > I'm using the following function in cell C3:
> > >
> > > =IF($A1="Network", AND(ISNUMBER(FIND("h",$B3))))
> > >
> > > The result in C3 is TRUE. If the value in A1 = network and the value
in
> > B3
> > > is "h", give me the number 1 in cell C3 instead of TRUE. If the
result is
> > > FALSE, I'd like the cell to be blank. Any ideas are greatly
appreciated.
> > >
> >
> >
> >

[pomalley]

Worked like a charm. Thanks so much.

"N Harkawat" wrote:

> Simply put a -- (double negative) in front of your formula to look like this
>
> --IF($A1="Network", AND(ISNUMBER(FIND("h",$B3))))
>
> becasue --(True) is equal to 1 and --False = 0
>
>
> "pomalley" <pomalley@discussions.microsoft.com> wrote in message
> news:D9481CD3-C45C-4466-9145-6E0B07D246FF@microsoft.com...
> > I'm using the following function in cell C3:
> >
> > =IF($A1="Network", AND(ISNUMBER(FIND("h",$B3))))
> >
> > The result in C3 is TRUE. If the value in A1 = network and the value in
> > B3
> > is "h", give me the number 1 in cell C3 instead of TRUE. If the result is
> > FALSE, I'd like the cell to be blank. Any ideas are greatly appreciated.
> >
>
>
>