Formula for if

[Mukesh8734]

G	1431 MZW	=IF(E5="?????M","Magus","Apex") I want to find a value if character in 2nd column match with letter M and it displayed Magus otherwise Apex	49.651
G	1431 MVZW		1.985
G	1431 MZW SUPER JUMBO		21.619
G	1431 MZW		14.208
G	1425 MZW		30.951

[#2]

@Mukesh8734 

=IF(ISNUMBER(SEARCH("M",E5)),"Magnus","Apex")

Is this what you are looking for?