On Wed August 9 2006 18:36, + Tobias Herbst wrote: > Hi I'm using OO 2.0.2 on my Windows XP PC and what my Problem is, you can > see it on the picture. Why does my WENN string works up to line 109 and > then not longer since line 110? > > V109: =WENN(G109=P109;"~";WENN(P109>S109;"+";WENN(P109=S109;"~";"-"))) > W109: > =WENN(G109=1;(4/24);WENN(E109=1;WENN(G109=0;WENN(V109="+";(P109-S109)*1,25; >W > ENN(V109="-";(S109-P109)*1,25;0));0);WENN(G109=0;WENN(V109="+";P109-S109;WE >N N(V109="-";S109-P109;0));0))) > > V110: =WENN(G110=P110;"~";WENN(P110>S110;"+";WENN(P110=S110;"~";"-"))) > W110: > =WENN(G110=1;(4/24);WENN(E110=1;WENN(G110=0;WENN(V110="+";(P110-S110)*1,25; >W > ENN(V110="-";(S110-P110)*1,25;0));0);WENN(G110=0;WENN(V110="+";P110-S110;WE >N N(V110="-";S110-P110;0));0))) >
Hi Tobias, As you are not subscribed you may not have seen that there was several posts on your questions with the final answer being : On Thu August 10 2006 15:03, Andreas Saeger wrote: > Sorry again. Just closed the test-sheet and on save-request I saw two > inconsistant results. > > Andreas Saeger wrote: > > Then I toggled the formula to absolute columns (Shift+F4), copied it to > > the right and did the following steps: > > X109: > > =IF($G109=1;4/24;IF($E109=1;IF($G109=0;ABS($S109-$P109)*5/4;0);IF($G109=0 > >;ABS($S109-$P109);0))) > > which is in pseudo-code: > =IF($G=1; > 4/24 > ; > IF($E=1; > IF($G=0; > ABS($S-$P)*5/4 > ; > 0 > ); > IF($G=0; > ABS($S-$P) > ; > 0 > ) > ) > ) > </pseudo-code> > The confusing thing is twice IF($G=0;... > <pseudo-code> > =IF($G=1; > 4/24 > ; > IF($G=0; > ABS($S-$P)*IF($E=1;5/4;1) > ; > 0 > ) > ) > </pseudo-code> > Y109: =IF($G109=1;4/24;IF($G109=0;ABS($S109-$P109)*IF($E109=1;5/4;1);0)) > > Does this help? > > > Btw: This simple macro converts localized formulas: > > http://www.oooforum.org/forum/viewtopic.phtml?t=23270 > > I use it with Ctrl+Shift+F1 Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
