| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested IF or( If And ) can't get it to work
=IF(AND(E6="",F6=""),"",IF(AND(E6="Half
Day",F61),0.5,IF(AND(E6<1,F61),1,F6-E6+1))) -- __________________________________ HTH Bob "John" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested IF or( If And ) can't get it to work
Thank you very much Bob
Believe it or not I tried it more then once and could not get it to work, I must of screwed up on the syntax, and spent hours trying to get it to work. Regards John "Bob Phillips" wrote in message ... =IF(AND(E6="",F6=""),"",IF(AND(E6="Half Day",F61),0.5,IF(AND(E6<1,F61),1,F6-E6+1))) -- __________________________________ HTH Bob "John" wrote in message ... 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 |
| Reply |
| 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)
Linear Mode
