samedi 7 juillet 2018

wrong number of arguements to if

Working on a payroll integration sheet for a tiered payroll structure. I have rearranged to allow for IF and THEN structure, tried as IF condition for validation only. Bending my eyes around this and hoping someone can prodigy this quickly without losing my mind today. I know im overlooking it, whos got fast eyes here. enter image description here

original:

=IF(AND(C26<23.9),(C26=24-31.9),(C26=32-39.9),(THEN(B26*11,B26*12,B26*13,B26*14)))

Aucun commentaire:

Enregistrer un commentaire