Convert TRUE/FALSE results to a number
 

Im 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, Id like the cell to be blank. Any ideas are greatly appreciated.

=if(conditionistrue,1,"")

--
Don Guillett
SalesAid Software

"pomalley" wrote in message
...
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.

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

"pomalley" wrote in message
...
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.

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" wrote in message
...
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.

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

--
Don Guillett
SalesAid Software

"pomalley" wrote in message
...
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

"pomalley" wrote in message
...
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.

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" wrote in message
...
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.