I'm doing a staffing allocation. I have PT for part time staff. I want PT
to equal 0.5 in my formula. My formula now is =countif(a1:a3,"pt") How do I
make PT=0.5?
I'm doing a staffing allocation. I have PT for part time staff. I want PT
to equal 0.5 in my formula. My formula now is =countif(a1:a3,"pt") How do I
make PT=0.5?
=COUNTIF(A1:A3,"PT")*0.5
HTH
Steve
The COUNTIF() function in your context, counts occurences of "pt" in
the specified range. It sounds like you want the resulting count of
"pt" to have 1/2 the weight of a full time employee. If that's
correct, your formula would need to include "/2" or "*.5" (no quotes,
of course) to halve the weight.
J,
=countif(a1:a3,"pt")/2
HTH,
Bernie
MS Excel MVP
"JGreig" <[email protected]> wrote in message
news:[email protected]...
> I'm doing a staffing allocation. I have PT for part time staff. I want PT
> to equal 0.5 in my formula. My formula now is =countif(a1:a3,"pt") How do I
> make PT=0.5?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks