How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,831
- Office Version
- 2010
- Platform
- Windows
I've lost myself with this formula...
=IF(AND(AG$7>=$L9-DAY($L9)+1,AG$7<=$N9),IF(DATE(YEAR($L9),MONTH($L9),1)<=AG$7,IF($N9>=AG$7,1,0),0),"")
That formula wasn't working until I swopped the value if true and the value if false around...
However what I want is the formula not to calculate when the logical test is false...
So before the change of the value if true and value is false I had:
=IF(AND(AG$7>=$L8-DAY($L8)+1,AG$7<=$N8),"",IF(DATE(YEAR($L8),MONTH($L8),1)<=AG$7,IF($N8>=AG$7,1,0),0))
What should I use to have "" as value if true WHEN the logical test isn't true... Does that even make sense...!
=IF(AND(AG$7>=$L9-DAY($L9)+1,AG$7<=$N9),IF(DATE(YEAR($L9),MONTH($L9),1)<=AG$7,IF($N9>=AG$7,1,0),0),"")
That formula wasn't working until I swopped the value if true and the value if false around...
However what I want is the formula not to calculate when the logical test is false...
So before the change of the value if true and value is false I had:
=IF(AND(AG$7>=$L8-DAY($L8)+1,AG$7<=$N8),"",IF(DATE(YEAR($L8),MONTH($L8),1)<=AG$7,IF($N8>=AG$7,1,0),0))
What should I use to have "" as value if true WHEN the logical test isn't true... Does that even make sense...!