Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula multiply and divide by single select column

Topic Labels: Formulas
Solved
Jump to Solution
380 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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