EXCEL FORMULA FOR BONUS CALCULATION

 

BONAS KA FORMULA  :-     

=IF(D1="A",C1*10%)    

=IF(D1="B",C1*10%)        

=IF(D1="C",C1*10%)     

=IF(D1="D",C1*10%)     

=IF(D1="E",C1*10%)     

=IF(D1="F",C1*10%)     

=IF(D1="G",*10%)

 =IF(D1="A",C1*10%,IF(D1="B",C1*10%,IF(D1="C",C1*10%,IF(D1="D",C1*10%,IF(D1="E",C1*10%,IF(D1="F",C1*10%,IF(D1="G",C1*10%)))))))