| if-then-else construction in Excel formula
if (a1 = 1 && b1 = 2)
{
c1 = 1;
}
elsif (a1 =2 && b1 = 3)
{
c1 = 2:
}
I tried to get the above in an Excel formula for field C1:
=IF((A1=1)*AND(B1=2);1;*OR(IF((A1=2)*AND(B1=3);2;999)))
It doesn't work. Somebody any idea? |