ExcelBanter - Assigning a numeric value to a alpha character

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Assigning a numeric value to a alpha character (https://www.excelbanter.com/excel-programming/352343-assigning-numeric-value-alpha-character.html)

Johnny D[_2_]

Assigning a numeric value to a alpha character

I have created an Employees Absentee Grid to keep up with days missed.
I.e."V" stands for a whole vacation day missed, which equals "1" whole day
missed. And i want to assign "HD" to stand for ".5" day missed. Formula,
PLEASE???????

Tom Ogilvy

Assigning a numeric value to a alpha character

=if(A1="V",1,if(A1="HD",.5,0))

=Countif(A1:Z25,"V")*1 + Countif(A1:Z25,"HD")*0.5

--
Regards,
Tom Ogilvy

"Johnny D" wrote in message
...
I have created an Employees Absentee Grid to keep up with days missed.
I.e."V" stands for a whole vacation day missed, which equals "1" whole day
missed. And i want to assign "HD" to stand for ".5" day missed. Formula,
PLEASE???????

All times are GMT +1. The time now is 05:03 AM.