Guy Voets wrote:
2010/1/26 Wade Smart <[email protected]>:
=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...
Not on my build.
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
