View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

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