If Functions Intersection

[Joko Purnomo]

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

 

[Alex Blakenburg]

Try this in C2:

=IF($B2>210,"Over 210",IF($B2>90,"91-210",IF($B2>30,"31-90",IF($B2>0,"1-30","Current"))))