Re: [users] Using an OR inside an IF

[Guy Voets]

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?
>
> Wade

Hello Wade,

for starters, OOo uses semi-colon instead of comma...

-- 
Guy

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org