mardi 26 mars 2019

What is the IF THEN formula for determining different pay levels. Produce 25 to 30 hours, eceive $1.50 per hour increase

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