| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF or( If And ) can't get it to work
HI Everyone
I'm working on a Vacation Planner and just can't get it to work. E6 and F6 are dates, G6 is the total of days from F6-E6. The formula below seems to work except when the cell is empty its still giving me a count of 1 in G6. =IF(AND(E6="Half Day",F61),0.5,IF(AND(E6<1,F61),1,F6-E6+1)) From To Qty E6 F6 G6 12/08/2008 20/08/2008 19 OK starting date included Empty 20/08/2008 1 OK Half Day 20/08/2008 0.5 OK Empty Empty I'm getting 1 Not ok I tried different IF function but I can't get 4 condition working I would appreciate some help please Thank you John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why doesn't writing a nested IF function work? | Excel Discussion (Misc queries) | |||
| nested if doesn't work | Excel Discussion (Misc queries) | |||
| nested vlookup does not work | Excel Worksheet Functions | |||
| Why doesn't this nested IF statement work? | Excel Worksheet Functions | |||
| Nested IF - Work Around for 7 nest Max | Excel Worksheet Functions | |||
![John[_22_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
