Hi
I have this formula and its not working, any help?
=IF(OR(ISNUMBER(FIND("RED",AF2)),ISNUMBER(FIND("BLU",AF2))),"BLUE",IF(ISNUMBER(FIND("GRN",AF2)),"GREEN",AF2))
I am having problems with the red part of the forumula. whe red is present in the cell it doesnt show red, its shows blue instead.
Any ideas?
thanks
I have this formula and its not working, any help?
=IF(OR(ISNUMBER(FIND("RED",AF2)),ISNUMBER(FIND("BLU",AF2))),"BLUE",IF(ISNUMBER(FIND("GRN",AF2)),"GREEN",AF2))
I am having problems with the red part of the forumula. whe red is present in the cell it doesnt show red, its shows blue instead.
Any ideas?
thanks