| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple IF Function
I am trying to calculate accrued vacation. Our employees accrue 6.667
hours/month. For someone who has more than one year of service, I have the following formula: =(IF(U11,MONTH(E8)*6.667,U1*6.667)-6.6667) U1 = Years of service E8 = TODAY() I need to add a nested function to the above which would calculate the accrual if Cell U1 is <1. Can anybody help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple IF function (maybe OR) | Excel Worksheet Functions | |||
| Multiple IF Function | Excel Worksheet Functions | |||
| Multiple results from multiple criteria using IF function | Excel Discussion (Misc queries) | |||
| Multiple Sheet, Multiple Criteria Look-Up Function Help | Excel Worksheet Functions | |||
| Multiple OR function | Excel Worksheet Functions | |||
Threaded Mode
