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
|