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/
