Formulas/Calculations

  • Thread starter Thread starter F. Dupont
  • Start date Start date
F

F. Dupont

I need a formula whereby when I type the letter "v" for
Vacation in a cell or "S" for Sick Day in a cell, that I
get excel to calculate it as half a day. I was able to
get it to work for a full day but I need it to give me a
calculation for 1/2 a day. Right now in my spreadsheet
when I type in the letter V or S it calculates V as 1 or
S as 1 and I need a letter to give me a calculation of
1/2 a point. Can this be done?
 
Assuming you want a new letter "H" to give 0.5,
and col A, row1 down is where you will enter the letters
"V","S" or "H":

Try something like this in B1:

=IF(OR(TRIM(A1)="V",TRIM(A1)="S"),1,IF(TRIM(A1)="H",0.5,""))

Copy B1 down col B

Note: It's case-insensitive, i.e. either upper or lower case letters will
work
 
Back
Top