I have a pay system that increases the bonus production as more hours are produced by the ASE technician. I would like to have one formula where I am able to enter one number for data entry. But I would have 5 different levels of pay increase. I have my spreadsheet set up. However, the following formula I created is incorrect: if(b9>=45,b9*o9,if(b9>=40,b9*n9,if(b9>=35,b9*m9,if(b9>=30,b9*l9,if(b9>=25,b9*k9)))))
if(b9>=45,b9*o9,if(b9>=40,b9*n9,if(b9>=35,b9*m9,if(b9>=30,b9*l9,if(b9>=25,b9*k9)))))
if(b9>=45,b9*o9,if(b9>=40,b9*n9,if(b9>=35,b9*m9,if(b9>=30,b9*l9,if(b9>=25,b9*k9)))))
No results as of yet.
Aucun commentaire:
Enregistrer un commentaire