If or??

[yanyanyan]

Hi everyone

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

Days Over due	Less than 30	30-59	60-90	90-179	More Than 180
20	(i need a fomula here, say if it's true return "1")
80			Same as here

<tbody>
</tbody>

 

[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!!