Thread: Excel formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Excel formula

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.