Maptitude Help / Formulas, Conditions, and Functions / Combining Formulas and Conditions

Combining Formulas and Conditions

You can use conditional expressions in formula. Since True and False are equivalent to the numbers 1 and 0, you can also do mathematical calculations using the result of a condition. Here are some examples:

Formula with Condition	Description
(if Population > 50000 then "Big" else "Small")	Returns the string "Big" if the value in the Population field is above 50,000, otherwise returns the string "Small"
(City = ‘Boston’) * 25	Returns the number 25 if the value in the City field is “Boston,” otherwise returns 0
(if HHI between 1000 and 2500 then H1 else H2)	If the value in the HHI field is in the range from 1,000 to 2,500 return the value in the H1 field, otherwise return the value in the H2 field

You can use formulas in conditions, to calculate a value needed for the logical test. Here are some examples:

Condition with Formula	Description
Population / Area > 1000	True if the population density is over 1000 people/areal unit, False otherwise
A.City + ‘ ‘ + A.State = B.[City & State]	True if the combined City and State fields in table A contain the same string as the [City & State] field in table B, False otherwise
Round([Avg Cost],2) le 1.25	True if the rounded [Avg Cost] field is less than or equal to 1.25, False otherwise