[users] stumped by nested if in calc

[Eric Wood]

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]