software

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 amp; 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 BE5I don't really understand what it is that you are doing or what it is you
are asking but looking at your formula a couple of things stand out.

If the formula is array entered, (Ctrl Shift Enter), the A6=$M$2:$M$5
will return an array of TRUE/FALSE's and the formula will only use the first
TRUE/FALSE (if not array entered I get a #VALUE! error). If you mean if the
value in A6 is also anywhere in the range M2:M5 then if it would be better
to use something likeCOUNTIF($M$2:$M$5,A6) to return a number or zero. (not
that zero is not a number but IF uses zero to mean FALSE).

Your formula will then become:

=IF(COUNTIF($M$2:$M$5,A6),G6/12/100*0.14*12/52,IF(COUNTIF($O$2:$O$5,A6),G6/12/100*0.14*12/52*2),quot;quot;)
(I assume that $O$2:$O$4 is a typo for $O$2:$O$5)

I also added quot;quot; as a FALSE argument otherwise you will get FALSE returned
when there is no match in M or O--
HTH

Sandy
with @tiscali.co.ukquot;ABquot; gt; wrote in message
...
gt; Hi All,
gt;
gt; I am putting together a formula that will help me determine if someone is
gt; paid weekly or bi-weekly. I currently have a payroll codes in Column A
gt; and
gt; then in Columns M amp; O I have the codes broken up into weekly and biweekly.
gt; I
gt; am also trying to link a salary amount which is in column G.
gt;
gt; Here is the formula I have already put together but I need some help.
gt;
gt; =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))
gt;
gt; Any and all assistance would be greatly welcomed.
gt;
gt; Here is a little snippet of my spreadsheet.
gt;
gt; Thanks.
gt; Adam
gt;
gt; A G J M
gt; O
gt; Co Code Salary Answer Co Code (weekly) Co
gt; Code
gt; (bi-weekly)
gt; BE5 19760 BE5
gt;