Skip to main content
Solved

Formula multiply and divide by single select column

  • January 20, 2022
  • 1 reply
  • 30 views
L

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)

Best answer by augmented

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 reply

A
Forum|alt.badge.img+18
  • augmented
  • Inspiring
  • Answer
  • January 20, 2022

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
  )
)
L
Terms & ConditionsAccessibility statement