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
380 1
cancel
Showing results for
Did you mean:  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) 1 Solution

Accepted Solutions  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
)
)``````  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
)
)`````` 