Making a letter equal 1 formula


G

Guest

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
 
Ad

Advertisements

G

Guest

Either I did something wrong or it does not work. I entered this formula in a
cell. I then Typed 'V', but nothing showed up in my totals.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top