I’ve got two columns “O” and “P” in a google spreadsheet.

I’m trying to fill column “O” with text based on numerical input in column “P” e.g. if “3” is typed into cell P3, fill cell“O3” with text “Laser, punch, debur in progress”, here’s what I tried:

=ARRAYFORMULA(IF(P2:P<>"",IF(P2:P = "1", "CAD Programming in progress",if(P2:P = "2", "CAD Programming finished", "in progress")),""))

Works but I get to use only two arguments.

=ARRAYFORMULA(IF(P2:P<>"",IF(P2:P="1","CAD Programming in progress"), if(P2:P="2","CAD Programming finished", if(P2:P="3","Laser, puch, debur in progress", if(P2:P="4","Laser, puch, debur finished", if(P2:P="5","Fold in progress", if(P2:P="6","Fold finished", if(P2:P="7","Bush in progress",))))))))

Works only for the first argument and all others return FALSE.

=ARRAYFORMULA(IF(P2:P<>"",IF(P2:P = "1", "CAD Programming in progress",if(P2:P = "2", "CAD Programming finished",if(P2:P = "3", "Something 3 in progress","in progress")),"")))

Wrong number of arguments to IF. Expected between 2 and 3 arguments, but got 4 arguments.

Here is the link to the spreadsheet:

https://docs.google.com/spreadsheets/d/1gMMH3UUAPmGKIc4V-tGddy5XokROjXvoKyhdCjQv0X4/edit?usp=sharing

And here is a link for what text needs to be filled for every number:

https://docs.google.com/spreadsheets/d/1tbxLuKe6-MdndI25wl7COzBvCuKBdU9Wi6LFdQsl2F0/edit?usp=sharing