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
 
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.
 

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

Similar Threads

Help with IF function 3
vacation formula and 1/2 days 8
IF Function and Specific Sum Entry 2
Formula - IF / OR ??? 5
Auto populating and assigning numeric value to a number 7
Excel 1
Excel Byte Calculation 2
Timeshets 1

Top