| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
IF Function
Sounds like you already know the answer. You would need to change the setup so that you can account for more than one type of leave per day in the first place. It should be by codes such as ord 1.5 and 2T SP PAL. You will then still have to get your colleagues to enter the code somewhere, rather then using the cell's location. This would make it more "secure". No "accidental" faulty returns. Good Luck -- bill k ------------------------------------------------------------------------ bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821 View this thread: http://www.excelforum.com/showthread...hreadid=481998 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Threaded Mode
