Formula to multiply by a number based on dropdown item selected

Platform discussions
1

Hi! I am trying to set a formula to calculate the following if possible:

If dropdown item selected is Initial, then calculate the numerical value in the Seat Time column by 125. If dropdown item selected is Subsequent, then calculate the numerical value in the Seat Time column by 63.2.

Thank you in advance!

K

2

@khampton0901

SWITCH({Dropdown#Labels}, "Initial", {Seat Time} * 125, "Subsequent", {Seat Time} * 63.2, "ERROR")

Jim - The Monday Man channel