Forum Discussion

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

Subodh_Tiwari_sktneer

Silver Contributor

Sep 24, 2019

Halikarnas76

You should try it like this..

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

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