Need help with Syntax with IF OR

[lgia]

I am having problems with trying to get this function to work. The Search function in the command seems to require a different format.

Basically I am checking a long GL string,
If $A2 contains 509 fill the cell with 509,
If $A2 contains 511 fill the cell with 511,
If $A2 contains 510 fill the cell with 510, else fill the cell with the contents of $A2

This command works for 1 if, but when I add the OR and try to do a string of Ifs it doesn't work.

=IF(OR(ISNUMBER(SEARCH(509,$A2)),509),ISNUMBER(SEARCH(511,$A2)),511),ISNUMBER(SEARCH(510,$A2)),510,$A2)))

 

[etaf]

not sure what this is doing
OR(ISNUMBER(SEARCH(509,$A2)),509)
as its closing the OR

=IF(ISNUMBER(SEARCH(509,$A2)),509, IF(ISNUMBER(SEARCH(511,$A2)),511,IF(ISNUMBER(SEARCH(510,$A2)),510,$A2)))

 

[lgia]

Thank you that did the trick, didn't even need the OR.

 

[etaf]

your welcome