Formula for if

New Contributor
G1431 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 Apex49.651
G1431 MVZW 1.985
G1431 MZW SUPER JUMBO 21.619
G1431 MZW 14.208
G1425 MZW  30.951
1 Reply

@Mukesh8734 

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

 

Is this what you are looking for?