I found the answer of this, it is like if(a1=b1,1,if(a2=b2,2,0))

"JIM.H." wrote:

Hello,
Is it possible to create a nested if statment in excel?
Thanks,
Jim.