Discussion To use more than one IF formula in Excel
https://techcommunity.microsoft.com/t5/excel/to-use-more-than-one-if-formula/m-p/871494#M40618
<P>Good day to all</P><P> </P><P>I want to use more than one IF in formula to calculate commission amount to be given from the profit.My formula is =IF(C4>20%*C21;3%*C4;IF(C4>40%*C21;5%*C4;"No Bonus")) All the time only the first logical test is being made by excel the second logical test after from second IF is being ignored.</P><P> </P><P>C21 is total cost and C4 is the profit. What i want to make is to give different commission per different profit level. Can someone help ? </P>Tue, 24 Sep 2019 06:31:39 GMTHalikarnas762019-09-24T06:31:39ZTo use more than one IF formula
https://techcommunity.microsoft.com/t5/excel/to-use-more-than-one-if-formula/m-p/871494#M40618
<P>Good day to all</P><P> </P><P>I want to use more than one IF in formula to calculate commission amount to be given from the profit.My formula is =IF(C4>20%*C21;3%*C4;IF(C4>40%*C21;5%*C4;"No Bonus")) All the time only the first logical test is being made by excel the second logical test after from second IF is being ignored.</P><P> </P><P>C21 is total cost and C4 is the profit. What i want to make is to give different commission per different profit level. Can someone help ? </P>Tue, 24 Sep 2019 06:31:39 GMThttps://techcommunity.microsoft.com/t5/excel/to-use-more-than-one-if-formula/m-p/871494#M40618Halikarnas762019-09-24T06:31:39ZRe: To use more than one IF formula
https://techcommunity.microsoft.com/t5/excel/to-use-more-than-one-if-formula/m-p/871507#M40619
<P><LI-USER uid="414041"></LI-USER> </P><P>You should try it like this..</P><P> </P><P><STRONG>=IF(C4>40%*C21,5%*C4,IF(C4>20%*C21,3%*C4,"No Bonus"))</STRONG></P>Tue, 24 Sep 2019 06:54:45 GMThttps://techcommunity.microsoft.com/t5/excel/to-use-more-than-one-if-formula/m-p/871507#M40619Subodh_Tiwari_sktneer2019-09-24T06:54:45ZRe: To use more than one IF formula
https://techcommunity.microsoft.com/t5/excel/to-use-more-than-one-if-formula/m-p/871511#M40620
<P>Thanks for quick help<LI-USER uid="394231"></LI-USER> </P><P> </P><P>But i already tried to use comma instead of semicolon. Here is the error message in attached</P><P> </P><DIV class="mceNonEditable lia-copypaste-placeholder"> </DIV>Tue, 24 Sep 2019 07:02:52 GMThttps://techcommunity.microsoft.com/t5/excel/to-use-more-than-one-if-formula/m-p/871511#M40620Halikarnas762019-09-24T07:02:52ZRe: To use more than one IF formula
https://techcommunity.microsoft.com/t5/excel/to-use-more-than-one-if-formula/m-p/871516#M40622
<P><LI-USER uid="414041"></LI-USER> </P><P>I forgot to replace the comma with semicolon in the proposed formula.</P><P>Please try it like this...</P><P> </P><P><STRONG>=IF(C4>40%*C21;5%*C4;IF(C4>20%*C21;3%*C4;"No Bonus"))</STRONG></P><P> </P><P>If that answers your original question, please take a minute to accept this post as an Answer to mark your question as Solved.<BR /></P>Tue, 24 Sep 2019 07:06:04 GMThttps://techcommunity.microsoft.com/t5/excel/to-use-more-than-one-if-formula/m-p/871516#M40622Subodh_Tiwari_sktneer2019-09-24T07:06:04ZRe: To use more than one IF formula
https://techcommunity.microsoft.com/t5/excel/to-use-more-than-one-if-formula/m-p/871521#M40624
<P><LI-USER uid="394231"></LI-USER> </P><P> </P><P>OMG I found the mistake. I was trying to calculate only percentage. So i changed the formula as to =IF(C4>1.4*C21;5%*C4;IF(C4>1.2*C21;3%*C4;"No Bonus")) and it`s working perfect. Thanks for your help my friend. </P>Tue, 24 Sep 2019 07:18:39 GMThttps://techcommunity.microsoft.com/t5/excel/to-use-more-than-one-if-formula/m-p/871521#M40624Halikarnas762019-09-24T07:18:39ZRe: To use more than one IF formula
https://techcommunity.microsoft.com/t5/excel/to-use-more-than-one-if-formula/m-p/871522#M40625
<P><LI-USER uid="414041"></LI-USER> </P><P>You're welcome!</P>Tue, 24 Sep 2019 07:20:29 GMThttps://techcommunity.microsoft.com/t5/excel/to-use-more-than-one-if-formula/m-p/871522#M40625Subodh_Tiwari_sktneer2019-09-24T07:20:29Z