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