Assign .5 to another letter or combination of letters like HD for half-day


Gord Dibben MS Excel MVP

On Fri, 30 Jun 2006 11:56:29 -0500, Carmel
wrote:


Using the countif function would assign a value of 1 to each occurence
of "V" for vacation. But how about if you only wanted it to have a
value of .50? for a half day....???