I am trying the find a solution for the following multiple formula (example);
IF(A1="K"; B1+(B1*C10);B1) AND IF(A1="N";B1+(B1*C11);B1). So actually two
expressions in one formula. I can't find a good solution. Is there anybody
who can help me? Thank you in advance.

Ad Buijs

=B1+B1*IF(A1="K",C10,if(A1="N",C11,0))


"Ad Buijs" wrote:

I am trying the find a solution for the following multiple formula (example);
IF(A1="K"; B1+(B1*C10);B1) AND IF(A1="N";B1+(B1*C11);B1). So actually two
expressions in one formula. I can't find a good solution. Is there anybody
who can help me? Thank you in advance.

Ad Buijs

IF(A1="K"; B1+(B1*C10);IF(A1="N";B1+(B1*C11);B1))

"Ad Buijs" wrote:

I am trying the find a solution for the following multiple formula (example);
IF(A1="K"; B1+(B1*C10);B1) AND IF(A1="N";B1+(B1*C11);B1). So actually two
expressions in one formula. I can't find a good solution. Is there anybody
who can help me? Thank you in advance.

Ad Buijs

If I am understanding your correctly, the following nested IF function should
work:

=IF(A1="K", B1+(B1*C10), IF(A1="N", B1+(B1*C11), B1))

This translates to the following: "If A1 is equal to K then evaluate and
display the result of B1+(B1*C10); otherwise check if A1 is equal to N then
evaluate and display the result of B1+(B1*C11); otherwise evaluate and
display the result of B1.

In this case, A1 equals neither K nor N, the value of B1 is displayed, which
seems to be what you outlined in your post.

I hope that this helps.


"Ad Buijs" wrote:

I am trying the find a solution for the following multiple formula (example);
IF(A1="K"; B1+(B1*C10);B1) AND IF(A1="N";B1+(B1*C11);B1). So actually two
expressions in one formula. I can't find a good solution. Is there anybody
who can help me? Thank you in advance.

Ad Buijs