On Thu, 2005-03-03 at 12:24 -0500, 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?
<tip author="Jonathon Coombes" subject="Complex formula structure"
category="Calc">
When you are working with complex formula in Calc, you may want to use
the function autopilot on the function toolbar. This dialog offers a
second tab to show the structure of the formula. This will show you
graphically, where there may be problems.
</tip>
Regards
Jonathon
--
OOo Tips (RSS) - http://mindmeld.cybersite.com.au/tips.rss
OOo Knowledgebase - http://mindmeld.cybersite.com.au/
Cybersite Consulting - http://www.cybersite.com.au/
Training4Linux - http://www.training4linux.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
