Help

Formula multiply and divide by single select column

Topic Labels: Formulas
Solved
Jump to Solution
895 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lucas_Tjahjadi
5 - Automation Enthusiast
5 - Automation Enthusiast

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)

image

1 Solution

Accepted Solutions
augmented
10 - Mercury
10 - Mercury

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

See Solution in Thread

1 Reply 1
augmented
10 - Mercury
10 - Mercury

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