Help with Excel IF and AND or OR functions

[Lunarstar]

I would like the formula in M2 to also look at column and if "ADD" then REG. CUST. but if "REP" then REPEAT.  If neither than keep original source in L.

Thank you

[#2]

Try this:
IF(J2=“ADD”,”REG. CUST”,
IF(J2=“REP”,”REPEAT”,
L2))