formula help status

[erhan_79]

Hi there ;

i have a column which shows "day" value as below left , i would like to create a new column that  writing  status according to below rule

İf day column value is between -3 and +3 status = on time 

if day column is bigger than  +3 status is = late

if day column is smaller than -3 status is early

thanks in advance 

day	Status
0	On time
3	On time
5	Late
2	On time
1	On time
-6	Early
-4	Early
-3	On time
-1	On time

[az38 · Accepted solution]

Hi @erhan_79 

Status Column = 
SWITCH(TRUE(),
[day] < -3, "early",
[day] > 3, "late",
"on time"
)

[erhan_79]

Hi @az38 ;

you are perfect ! it is working thank you!