Hi All,

I am putting together a formula that will help me determine if someone is
paid weekly or bi-weekly. I currently have a payroll codes in Column A and
then in Columns M & O I have the codes broken up into weekly and biweekly. I
am also trying to link a salary amount which is in column G.

Here is the formula I have already put together but I need some help.

=IF(A6=$M$2:$M$5,G6/12/100*0.14*12/52,IF(A6=$O$2:$O$4,G6/12/100*0.14*12/52*2))

Any and all assistance would be greatly welcomed.

Here is a little snippet of my spreadsheet.

Thanks.
Adam

A G J M
O
Co Code Salary Answer Co Code (weekly) Co Code
(bi-weekly)
BE5 19760 BE5