Formula help

[sbaily]

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

 

[xld]

Try

=IF(ISNUMBER(FIND("RED",AF2)),"RED",IF(ISNUMBER(FIND("BLU",AF2)),"BLUE",IF(ISNUMBER(FIND("GRN",AF2)),"GREEN",AF2)))

 

[sbaily]

thats great thanks