Calculation to insert a number based on other field’s text

[phloem]

Field “location” has a pick list. Each location has a known kilometer distance.

I want a calculation field to give a number depending on the “location”. For example, the calculation field will insert “27” when the location is “ABS”. If the location is “Miya”, then “22” will be inserted.

I’ve tried the if and if equal but I can’t get it to work. What should the equation be for the above example?

• This topic was modified 1 day, 9 hours ago by phloem.

[Author]

Posts