Skip to main content

Hai, can anyone help me to write formula but based on single select column.

If single select = Kg will be multiply 1 ( * 1)

then If single select = Box will be multiply 5 (* 5)

and then if single select = 200 gram will be divide 5 (/ 5)


Hi Lucas. You want to use the SWITCH statement. Something like that below should work.


IF(AND({Jumlah (Kg)},Unit),

  SWITCH(Unit,

    "Kg", {Jumlah (Kg)},

    "Box", {Jumlah (Kg)} * 5,

    "200grm", {Jumlah (Kg)} / 5

  )

)

Reply


Terms & Conditions