Since they're mutually exclusive, one of the find statements will always return an error. Use the IsError function to test the validity of the find before using the result of the find. It means the find functions appear twice, but it's the only way I've found to do this.
tc
Eric Wood wrote:
If column A has these descriptions: 9.0 X 12.5 .003 FAST PAC BG 1000/RL 6 x 8 .004 BLK CONDUCT 100/CS
and Column B has this formula: =IF((FIND("1000/";A1)>1);"1";IF((FIND("100/";A1)>1);".1";"0"))
Why do I get a #VALUE! on the false conditions?
Thanks,
-Eric Wood
Calc 1.1.3
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
