Chris Waller
Board Regular
- Joined
- Jan 18, 2009
- Messages
- 183
- Office Version
- 365
- Platform
- Windows
I have just inherited a spreadsheet at work from someone who has left the office. The problem is with my lack of understanding about the following formula.</SPAN>
I just cannot get my head around it and I wondered if there was anyone that could explain in simple terms what it is supposed to be doing?</SPAN>
The cells A5, X2, X3 B5, Y2 and W3 ALL contain dates.
=IF(AND(A5<(X$2+1),B5<Y$2,B5>W$3),(((B5+1)-X$2)/7)*N5,IF(AND(B5<Y$2,A5>W$3),O5,IF(AND(B5>X$3,A5<Y$2,A5>X$2),(((X$3+1)-A5)/7)*N5,IF(AND(B5>X$3,A5<X$2),((Y$2-X$2)/7)*N5,0))))
I just cannot get my head around it and I wondered if there was anyone that could explain in simple terms what it is supposed to be doing?</SPAN>
The cells A5, X2, X3 B5, Y2 and W3 ALL contain dates.
=IF(AND(A5<(X$2+1),B5<Y$2,B5>W$3),(((B5+1)-X$2)/7)*N5,IF(AND(B5<Y$2,A5>W$3),O5,IF(AND(B5>X$3,A5<Y$2,A5>X$2),(((X$3+1)-A5)/7)*N5,IF(AND(B5>X$3,A5<X$2),((Y$2-X$2)/7)*N5,0))))
Last edited by a moderator:
