Forum Discussion

Halikarnas76's avatar
Halikarnas76
Copper Contributor
Sep 24, 2019

To use more than one IF formula

Good day to all   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 ti...
excel
Halikarnas76's avatar
Halikarnas76
Copper Contributor
Sep 24, 2019

Thanks for quick helpSubodh_Tiwari_sktneer 

 

But i already tried to use comma instead of semicolon. Here is the error message in attached

 

 
Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Sep 24, 2019

Halikarnas76 

I forgot to replace the comma with semicolon in the proposed formula.

Please try it like this...

 

=IF(C4>40%*C21;5%*C4;IF(C4>20%*C21;3%*C4;"No Bonus"))

 

If that answers your original question, please take a minute to accept this post as an Answer to mark your question as Solved.

  • Halikarnas76's avatar
    Halikarnas76
    Copper Contributor
    Sep 24, 2019

    Subodh_Tiwari_sktneer 

     

    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. 

Resources