View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Randy
 
Posts: n/a
Default Making a letter equal 1 formula

I am setting up a vacation spraedsheet for work. Is there a way to enter V
for vacation day and have it equal one in my totals. I want to differentiate
vacation days from sick days for each employee. I have all the necessary
formulas set up to automatically deduct days if I enter the number 1, but I
would rather enter V and have it equal the number 1. Hope this makes
sense.....Thanks