Hi Wade, Sorry for the late reply. Yes, the second formula worked for me. I copied yours and modified it to get the first formula. You had stated in a previous message that in your build the comma works in a formula. When I pasted it into a spreadsheet to test it, I had to change the commas to semicolons. tc
________________________________ From: Wade Smart <[email protected]> To: [email protected] Sent: Thu, January 28, 2010 8:24:15 AM Subject: Re: [users] Using an OR inside an IF Were you able to run this in a spread sheet cell? Documentation says you can compare words, only numbers. 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 <[email protected]> > To: OpenOffice <[email protected]> > 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: [email protected] > For additional commands, e-mail: [email protected] > > > __________________________________________________________________ > 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: [email protected] For additional commands, e-mail: [email protected] __________________________________________________________________ Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now http://ca.toolbar.yahoo.com.
