You could setup an index column with your other data to take both type of
pay and shift into account, then have a table like the one below:

R|1 7.5
R|2 8
R|3 8
S|1 8
S|2 11
S|3 11
U|1 8
U|2 11
U|3 11
V|1 8
V|2 11
V|3 11

You could then use either the VLOOKUP or the combination of INDIRECT,
ADDRESS, and MATCH functions to find and record the proper values, depending
on what your circumstances are.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"bajanswing" wrote in message
...
Hello
I need help with a formula I'm using that is not functioning the way I
need
it to. I am trying to represent employee hours worked, sick, vacation
with a
letter such as "r"= 7.5 or 8 hrs, "u" =11 hrs, "s"= 8 or 11 hrs, "v"=8 or
11
etc....
I have three different shifts of hours the first one totals 81.25 (based
on
bi-monthy average) the second and the third is 86.67. one of the shifts
has
a modified schedule which usually consist of 11 days. This is where my
problem comes in. Because the fact that I have two shifts with the same
amount of scheduled hours, my formula will not calculate the proper number
of
sick, vacation or other days I need to represent.
Now this is how it is working right now:

M7=COUNTIF($AP7:BT7, "S")*IF(E7=81.25,7.5,IF(E7=86.67,8,IF(E7=83.42,11) ))
*note: I did not mention a shift with 83.42, that is because I don't have
one and need that to represent "11" hrs. Which means the above formula
has
to also read 86.67 in the final part of the equation. How do I do this?
Do
I need to represent it with another "countif" statement or an "if"?
How does 86.67 =8hr and/or 11 hrs without me having to manually adjust it
each time? Is there a way to colour code the selection in order for it to
tell the difference between the two and yet come up with the right answer?

HELP please!!! This has been plaquing me for sometime now.