Nested IF formula error

I would like to make a formula like this with Nocodb
IF(Pack=“X”,50,

IF(Pack=“Y”,8,

IF(Pack=“Z”,10,

IF(Pack=“R”,100,

IF(Pack=“F”,22,

IF(Pack=“O”,160,

IF(Pack=“E”,100,

IF(Pack=“D”,1000,

IF(Pack=“T”,99,

IF(Pack=“U”,500,

IF(Pack=“S”,30,

IF(Pack=“F”,30,

IF(Pack=“V”,50,

IF(Pack=“M”,50,

IF(Pack=“Q”,8,

IF(Pack=“P”,45,

IF(Pack=“U”,20,

IF(Pack=“C”,880,

IF(Pack=“L”,45,

IF(Pack=“oo”,88,0

))))))))))))))))))))

There is an issue with syntax in the formula you have pasted. Easier for this case will be to use Switch in the formula

SWITCH({Pack}, "X", 50, "Y", 8, "Z", 10, "R", 100, "F", 22, "O", 160, "E", 100, "D", 1000, "T", 99, "U", 500, "S", 30, "V", 50, "M", 50, "Q", 8, "P", 45, "C", 880, "L", 45, "oo", 88, 0)
1 Like