If or??

[yanyanyan]

Hi everyone

I wonder if formula will suit my simple need below? Thanks!!

[TABLE="width: 500"]
<tbody>[TR]
[TD]Days Over due[/TD]
[TD]Less than 30[/TD]
[TD]30-59[/TD]
[TD]60-90[/TD]
[TD]90-179[/TD]
[TD]More Than 180[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD](i need a fomula here, say if it's true return "1")[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]80[/TD]
[TD][/TD]
[TD][/TD]
[TD]Same as here[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Rada1]

If your days overdue are in column A, starting from A2, in:
B2 =IF(A2<30,"1","")
C2 =IF(AND(A2>=30,A2<=59),1,"")
D2 =IF(AND(A2>=60,A2<=89),1,"")
E2 =IF(AND(A2>=90,A2<=179),1,"")
F2 =IF(A2>180,"1","")

Copy formulas down.

Also, you can think about changing these absolute references to relative.

 

[yanyanyan]

Thanks!!