IF

[Rick.]

I do payroll, and I'm working in a formula to calculate split shifts (SS). I
have different rates and diferent amounts for x hors worked. For example
Rate 1: $8.50, when the employee works from 4 to 4.59 hrs so we pay the
employee $6.00 for SS, when is from 5 to 5:59 hrs the pay is $5.50 for SS.
Rate:2 $9.00, when works from 4 to 4:59 hrs the pay is $5.00 for SS.
This is the formula I was working on it:

=IF((A18=8.25)*AND(B18>=4)*(B18<5),"7",IF((B18>=5)*(B18<6),"6.75",IF((B18>=6)*(B18<7),"6.50",IF((B18>=7)*(B18<8),"6.25",IF((B18>=8)*(B18<9),"6",IF((B18>=9)*(B18<10),"5.75",IF((B18>=10)*(B18<11),"5.50",))))))
how can I add (A18=8.50) values?


How can I connect the different rates y its values together?

Thanks in advance for all your help.

Rick.

 

[KARL DEWEY]

Post your question to a newsgroup for Excel or other spreadsheet application.
This forum is for Access, a relational database that is part of Microsoft
Office Professional.