Formula multiply and divide by single select column

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
  )
)
1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.