Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula
J,
=countif(a1:a3,"pt")/2 HTH, Bernie MS Excel MVP "JGreig" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula
=COUNTIF(A1:A3,"PT")*0.5 HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=502461 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) |