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,"")

 

[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.

 

[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

 

[Don Guillett]

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

 

[pomalley]

Worked like a charm. Thanks so much.

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