Joko Purnomo
Board Regular
- Joined
- Jul 14, 2008
- Messages
- 62
- Office Version
- 2016
- Platform
- Windows
How to use if functions that intersection with each other , for example when due days 30 up when due days = > 30 and <= 210" while another part in the same column when due days 90 up means = > 90 and <= 210". 30+ is included all of 90+, meanwhile 90+ is 90 up.
Example:
Due Days : Result :
31 30+
50 30+
72 30+
98 30+ also 90+
105. 30+ also 90+
32. 30+
84 30+
How the formula, when we filter 30 up, all 30 up selected in the colom, and when we filter 90up, only dusle days with 90 day up will selected
Please help me sir! Thanks very much
Example:
Due Days : Result :
31 30+
50 30+
72 30+
98 30+ also 90+
105. 30+ also 90+
32. 30+
84 30+
How the formula, when we filter 30 up, all 30 up selected in the colom, and when we filter 90up, only dusle days with 90 day up will selected
Please help me sir! Thanks very much