| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Equal to or less than formula | Excel Worksheet Functions | |||
| Making a formula continuous | Excel Discussion (Misc queries) | |||
| Formula which is greater tahn or equal to zero | Excel Worksheet Functions | |||
| formula for calculating 401k if over or equal to 1 yr of service . | Excel Worksheet Functions | |||
| How do I get a letter in one cell ito equal a number in anotherl.. | Excel Discussion (Misc queries) | |||
Threaded Mode
