Convert TRUE/FALSE results to a number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Worked like a charm. Thanks so much.

N Harkawat said:
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
Click to expand...
 
Back
Top