Formula to change timezone based on single-select ...

[Lucas_Tjahjadi]

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)

[augmented · Accepted solution]

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