how to create a multiple conditional formula
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 |
All times are GMT +1. The time now is 08:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com