=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]
