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

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

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