2010/1/26 Wade Smart <w...@wadesmart.com>:
> =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?This works (I tried it) on OpenOffice.org 3.2 RC1: =IF(OR(F8="yellow";F8="y");5;0) =IF(OR(F8="yellow",F8="y"),5,0) on the other hand, gives ”Err:501”. I don't know what build you have. Maybe you use Excel? Excel accepts commas, as far as I've heard. Regards Johnny Rosenberg > > 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 > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
