Hi I want to create a formula with the following criteria If cell "A1" contains a certain word, say"water", put the value "4W" in cell "B1' If cell "A1" does not contain the word "water" check if A1 contains the word "fire" and if so put the value "4F" in cell "B1" If cell "A1" does not contain any of the words above allow a manual entry of my choice in cell "B1"
I think this should be easy but I cant seem to create a "contains" command. Equal to, less than, more than and range between, yes, but not contains. Its driving me mad so any help would be much appreciated. Also is there a way one can make a formula refer to a complete spreadsheet rather than copying the formula into each cell every time you make a new entry. Many thanks for any help you can give Derek Day [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
