Excel - IF funtion - Microsoft Community

i have 2 column , need return value if criteria meets

see below:

if a=4 , b=dfl other - other result need show.

thanks

4	dfl
4	dfl
4	dfl
4	dfl
4	dfl

use formula in cell, such c2 (it looks @ cells a2 , b2):

=if(and(a2=4,b2="dfl"),"other","")

Office / Excel / Windows 10 / Office 2016