Das können Sie nur selbst - keiner von den anderen Benutzern kann das
tun. Wie das funktioniert, habe ich Ihnen in meiner Mail von vor 2
Tagen ausführlich erklärt.
Nicht beschweren sondern selbst tätig werden.
Am Fri, 29 Jan 2010 07:24:03 +0100
schrieb Heinz Jürgen Niewel <heiju...@unitybox.de>:
> Streich mich endlich von der Liste
> ----- Original Message -----
> From: "Wade Smart" <w...@wadesmart.com>
> To: <users@openoffice.org>
> Sent: Thursday, January 28, 2010 7:26 PM
> Subject: Re: [users] Using an OR inside an IF
>
>
> >I still get a 508 error using it.
> > I still think its odd that I use ; and others use , so I guess some
> > can do that with text and others, like me, cant :D
> >
> > Wade
> >
> > Johnny Rosenberg wrote:
> >> 2010/1/28 Wade Smart <w...@wadesmart.com>:
> >>> Were you able to run this in a spread sheet cell?
> >>> Documentation says you can compare words, only numbers.
> >>
> >> I think they mean that things like
> >> =IF("Johnny">"Rosenberg";"Yes";"No") doesn't make much sense. But
> >> you can still test for = and ≠ (<>).
> >>
> >>
> >> Regards
> >>
> >> Johnny Rosenberg
> >>
> >>
> >>> Wade
> >>>
> >>>
> >>> Anthony Chilco wrote:
> >>>> Hi Wade,
> >>>> Off the top of my head, I'd say it should read
> >>>> =IF(OR(F8="yellow",F8="y"),5,0)
> >>>> Of course, I had to use semicolons to test it.
> >>>> =IF(OR(F8="yellow";F8="y");5;0)
> >>>> tc
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> ________________________________
> >>>> From: Wade Smart <w...@wadesmart.com>
> >>>> To: OpenOffice <users@openoffice.org>
> >>>> Sent: Tue, January 26, 2010 8:59:58 AM
> >>>> Subject: [users] Using an OR inside an IF
> >>>>
> >>>> =IF(F8=(OR("yellow","y")),5,0)
> >>>>
> >>>> IF, F8 is equal to the word "yellow" or the letter "y" then
> >>>> return the number 5, otherwise return 0.
> >>>>
> >>>> Im getting that #VALUE! error.
> >>>>
> >>>> ah.. I just read that any text cells are ignored.
> >>>> How would I do that then?
> >>>>
> >>>> Wade
> >>>> -- Registered Linux User: #480675
> >>>> Registered Linux Machine: #408606
> >>>> Linux since June 2005
> >>>>
> >>>> ---------------------------------------------------------------------
> >>>> To unsubscribe, e-mail: users-unsubscr...@openoffice.org
> >>>> For additional commands, e-mail: users-h...@openoffice.org
> >>>>
> >>>>
> >>>> __________________________________________________________________
> >>>> Looking for the perfect gift? Give the gift of Flickr!
> >>>> http://www.flickr.com/gift/
> >>>
> >>> --
> >>> Registered Linux User: #480675
> >>> Registered Linux Machine: #408606
> >>> Linux since June 2005
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: users-unsubscr...@openoffice.org
> >>> For additional commands, e-mail: users-h...@openoffice.org
> >>>
> >>>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: users-unsubscr...@openoffice.org
> >> For additional commands, e-mail: users-h...@openoffice.org
> >>
> >>
> >
> >
> > --
> > Registered Linux User: #480675
> > Registered Linux Machine: #408606
> > Linux since June 2005
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscr...@openoffice.org
> > For additional commands, e-mail: users-h...@openoffice.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@openoffice.org
> For additional commands, e-mail: users-h...@openoffice.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
